随笔: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';

posted @ 2023-11-15 12:23  MrLuyu  阅读(5)  评论(0)    收藏  举报