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