SQL
文章平均质量分 50
七宝
这个作者很懒,什么都没留下…
展开
-
Learning SQL
在学习SQL中在LEARNING SQL中摘录的笔记Learning SQL 1.去除重复的行SELECT DISTINCT cust_idFROM account;2.子查询根据其他查询再设置查询SELECT e.emp_id,e.name,e.lnameFROM (SELECT emp_id,fname,lname,start_date,title FR原创 2012-03-27 13:55:37 · 907 阅读 · 0 评论 -
Learning SQL --集合操作
Learning SQL --集合操作A+B A union B AB A intersect BA-B A except B1.union intersect exceptSELECT id,genderFROM student_listUNION ALLSELECT id,foodFROM favorite_food;UNION 去原创 2012-03-27 14:48:50 · 552 阅读 · 0 评论 -
Learning SQL2
Learning SQL2一 分组与聚集聚集函数--GROUNP BYmysql> SELECT gender,COUNT(*) how_many -> FROM student_list -> GROUP BY gender;+--------+----------+| gender | how_many |+--------+----------原创 2012-03-27 20:08:17 · 570 阅读 · 0 评论 -
Learning SQL3
CASE WHEN employee.title='Head Teller' THEN 'Head Teller' WHEN employee.title='Teller' AND YEAR(employee.start_date)>2007 THEN 'Teller TRAINEE' WHEN employee.title='Teller'原创 2012-03-27 20:54:58 · 661 阅读 · 0 评论 -
Learning SQL--多表查询
Learning SQL --多表查询1.笛卡尔积SELECT e.fname,e.lname,d.nameFROM employee e JOIN department d;2.内连接SELECT e.fname,e.lname,d.nameFROM employee e JOIN department dON e.dept_id=d.dept_id;==原创 2012-03-27 14:14:19 · 614 阅读 · 0 评论 -
SQL语言的分类
SQL语言的分类1、DML :即CRUD增删改查2、DDL:新建数据结构、修改数据接口、以及删除数据结构3、TCL:事务控制4、DCL:权限控制。using MySQL, count(*) will be fast under a MyISAM table but slow under an InnoDB. Under InnoDB you should use count(1) o...原创 2018-10-20 23:36:58 · 205 阅读 · 0 评论