2019-3-28 课前考

CREATE TABLE Studentss (
    id INT ( 4 ) PRIMARY KEY auto_increment,
    `name` VARCHAR ( 15 ),
    sex INT ( 4 ),
    phone VARCHAR ( 25 ),
    role INT ( 4 ),
    score INT ( 4 ) 
);
#给表添加数据
INSERT INTO Studentss ( `name`, sex, phone, role, score )
VALUES
    ( 'zhangsan', 2, '13837689458', 1, 54 ),
    ( 'lisi', 2, '18537689458', 2, 90 ),
    ( 'wanwu', 1, '15837689458', 3, 94 ),
    ( 'zhangsan', 2, '13037689458', 3, 82 );
    
    
#修改表数据    
UPDATE Studentss 
SET phone = '18516047693' 
WHERE
    `name` = 'lisi';
    
#查询数据    
SELECT
    * 
FROM
    Studentss 
WHERE
    score < 60;
    
#查询数据        
SELECT
    * 
FROM
    Studentss 
WHERE
    `name` LIKE = 'z%';
    
#查询数据        
SELECT
    * 
FROM
    Studentss 
WHERE
    role IN ( 1, 3 );
    
#删除数据    
DELETE 
FROM
    Studentss 
WHERE
    role = 1;
    
    #删除表
TRUNCATE Studentss;