增:
insert into tableName
(列1,列2,列3...列N)
values
(值1,值2,值3...值N)
//注意:列与值必须严格对应.
insert into tableName
//此处不声明列,则是要插入所有列.
values
(所有列对应的值);
删:
delete from tableName where 条件.
改:
update tableName
set
列1 = 值1,
列2 = 值2,
...
列N = 值N
where 条件.
查:
select */列1,列2,列N
from
tableName
where 条件