mysql
增
添加一行的全部数据
insert into students values(1,"李磊",23, 173.20, "男", 1);
添加多行数据
insert into students values(0,"张丽",25, 163.00, "女", 1), (0,"莉莉",20,178.50,"女",2);
按照字段添加数据
insert into students (name,age, height,gender, cid) values("刘亮", 19, 175.23,"男",2)
原创
2020-09-02 10:38:18 ·
202 阅读 ·
0 评论