SQL之数据表更新

UPDATE 表名 SET 字段名1=值1[,字段名2 =值2,…] [WHERE 条件表达式];

update student set age=20,gender='female' where name='tom';

update student set age=18;