1、update
ex: update repeat set name='t' where id=2
temp: update table_name t set t.name='ss' ,t.pwd='111122' where t.id=5;
----where t.id=5 and t.gender=1
2、delete
ex: delete from repeat where id=5
temp: delete from table where [condition]
多条数据删除
temp: delete from repeat where id<10 and id>7
----and name like '%oo%'
3、insert
ex: insert into repeat (name,id)values ('d',8);
temp: insert into table ([column..]) values ('','','');
4、select
select * from repeat ;
一般select查询比较复杂,以后详解
ex: update repeat set name='t' where id=2
temp: update table_name t set t.name='ss' ,t.pwd='111122' where t.id=5;
----where t.id=5 and t.gender=1
2、delete
ex: delete from repeat where id=5
temp: delete from table where [condition]
多条数据删除
temp: delete from repeat where id<10 and id>7
----and name like '%oo%'
3、insert
ex: insert into repeat (name,id)values ('d',8);
temp: insert into table ([column..]) values ('','','');
4、select
select * from repeat ;
一般select查询比较复杂,以后详解