MySQL之数据的增删改

添加数据

INSERT students (id,class_id,name,gender,score) 
VALUES (14,2,"赵强","男",79)

 

 

修改数据

UPDATE students SET NAME="威威" WHERE id=14

 

 不加where时所有的name都会被修改

删除数据

DELETE FROM students WHERE id >10 and id <14

或

DELETE FROM students WHERE id BETWEEN 10 AND 14
注：10 =< id =<14