随笔:Mysql增删改查
id,name,age,sex,score
增加两条数据:
insert into table_student values (0, 'name1', age1, 'sex1', score1),(1, 'name2', age2, 'sex2', score2);
将name1中的age1更新为age3:
update table_student set age=age3 where id =0;
删除name1的记录
delete from table_student where name = 'name1';

浙公网安备 33010602011771号