— 1、分页查询,limit后面第一个数代表从哪一条数据开始(下标从零开始),第二个数代表查几条
SELECT * FROM students WHERE stu_sex=1 LIMIT 0,3
— 2、插入语句
INSERT INTO students (stu_id,stu_name,stu_age,stu_sex,tea_id) VALUES (5,’王一博’,25,1,1)
— id设置自增时可以省略id字段
INSERT INTO students (stu_name,stu_age,stu_sex,tea_id) VALUES (‘邓论’,25,1,1)
— 可以直接写值
INSERT INTO students VALUES (7,’王一博’,25,1,1)
— 3、修改语句
UPDATE students SET stu_name = ‘黄景瑜’ WHERE stu_id = 7
— 4、删除语句
DELETE FROM students WHERE stu_id = 7
数据库之DQL分页查询&DML增删改
最新推荐文章于 2024-07-28 23:46:55 发布