3、简单的crud语句

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查询比较复杂，以后详解