随笔分类 -  Mysql

mysql04
摘要： 阅读全文
posted @ 2020-11-15 17:43 sean_wang 阅读(62) 评论(0) 推荐(0)
mysql03
摘要： 阅读全文
posted @ 2020-11-15 17:40 sean_wang 阅读(65) 评论(0) 推荐(0)
mysql02
摘要： 阅读全文
posted @ 2020-11-15 17:36 sean_wang 阅读(72) 评论(0) 推荐(0)
mysql执行顺序及习题
摘要：一、SELECT语句关键字的执行顺序 (7) SELECT (8) DISTINCT <select_list>(1) FROM <left_table>(3) <join_type> JOIN <right_table>(2) ON <join_condition>(4) WHERE <where 阅读全文
posted @ 2020-10-30 22:45 sean_wang 阅读(124) 评论(0) 推荐(0)
多表查询
摘要：-- 技术部花名册 -- select name as "技术部花名册" from employee where depart_id in (select id from department where name = "技术"); -- 平均年龄大于25的部门名称 -- select id,nam 阅读全文
posted @ 2020-10-30 22:39 sean_wang 阅读(296) 评论(0) 推荐(0)