1. insert插入數據

mysql> insert into score(xid,cid,score,quekao) values  ##在score表中插入括號中的四列
mysql> select * from score  ##查詢score表

2. update

mysql> select * from student;
mysql> update student set xname='xiaowang' where xid=6;
mysql> update student set xname='xiaozhang' where xid=5; 

delete

#插入數據：
mysql> insert into student values(21,'xiaoli',22,'f','123','456','上海市','2020-01-01')
#刪除插入的數據
mysql> delete from student where xid=行數;

##
偽刪除
（1）添加狀態(tài)列is_del（1代表刪除，0代表有效）
alter table student add is_del tinyint not null default 0 comment '1代表刪除,0代表有效';
select * from student;
（2）delete ---> update
原語句
delete from student where xid=20;
改為
update student set is_del=1 where xid=20;
（3）更改業(yè)務查詢方法
原語句
select * from student;
改為
select * from student where is_del=0;

舉例：如何刪除表中的范圍性數據
如刪除表中1-5行的數據
delete from t1 where name like '王二%';
delete from t1 where id>1 and id<5;
delete from t1 where id between 1 and 5;