常用sql语句-增删改

常用sql语句-增删改

sql

插入数据

• 插入一条数据

insert into tableName(field1,field2) values(value1,value2);

删除数据

• 删除一条数据

delete from tableName where ... limit 1;

• 删除多条数据

delete from tableName where ...;

更新数据

update tableName set field1=value1 where ...;