SELECT * FROM student;
SELECT s_id,s_name FROM student;
SELECT 'abc';
-- select的四大子句
-- where 条件
SELECT * FROM student WHERE s_sex='男';
SELECT * FROM student WHERE s_sex='女' AND s_birth ='1990-01-20'
-- 数据库中出生日期使用data类型
SELECT * FROM student AS a,score AS b
WHERE a.s_id =b.s_id;
-- order by 排序
SELECT * FROM student ORDER BY s_birth;
SELECT * FROM student
mysql入门,-- select的四大子句 -- where 条件-- 数据库中出生日期使用data类型-- order by 排序
最新推荐文章于 2022-12-12 11:21:14 发布