修改-删除表中数据

update xs

#更新xs的表

set xh = '000000' ,

#修改xh的列为6个0（要修改多个数据用逗号隔开）

name = 'qqqqqq'

#继续修改,修改name

where id = 1;

#指定修改id为1的xh列

===========================================

#删除id为1的整行的数据，从xs表中

-----

delete from xs where id =1;

===========================================

truncate table xs;

#清空所有行