mysql
文章平均质量分 82
Jettle-perfect
这个作者很懒,什么都没留下…
展开
-
网络资料附表: oracle 常用函数 与mysql 的对照表
网络资料附表:oracle 常用函数 与mysql 的对照表s:mysql o :oracle1. 绝对值 S:select abs(-1) value O:select abs(-1) value from dual2. 取整 ( 大 ) S:select ceiling(-1.001) value O:select ceil(-1.001) value from dual3. 取整(小) S:select floor(-1.001) value O:select flo...转载 2021-05-17 14:52:50 · 702 阅读 · 0 评论 -
SQL必知必会要点记录(4/6)
SQL必知必会要点记录(4/4)*外联结--LEFT OUTER JOIN:选择左侧表中的所有行;RIGHT OUTER JOIN:选择右侧表中的所有行SELECT Customers.cust_id , Orders.order_numFROM Customers LEFT OUTER JOIN OrdersON Customers.cust_id = Orders.cust_id ;*全外联结SELECT Customers.cust_id , Orders.order_numFROM原创 2021-05-13 16:26:04 · 153 阅读 · 0 评论 -
SQL必知必会要点记录(3/6)
SQL必知必会要点记录(3/4)*HAVING 前要结合GROUP BYSELECT vend_id , COUNT(*) AS num_prodsFROM ProductsWHERE prod_price >=4GROUP BY vend_idHAVING COUNT(*) >=2;*GROUP BY 与ORDER BY 再探SELECT order_num , COUNT(*) AS itemsFROM OrderItemsGROUP BY order_numHAV原创 2021-05-12 18:02:38 · 130 阅读 · 0 评论 -
SQL必知必会要点记录(2/6)
SQL必知必会要点记录(2/4)*字段拼接:+或者|| 或者,SELECT vend_name + '(' + vend_country + ')'FROM VendorsORDER BY vend_name;或者SELECT vend_name || '(' || vend_country || ')'FROM VendorsORDER BY vend_name;或者SELECT vend_name , '(' , vend_country , ')'FROM VendorsOR原创 2021-05-11 17:41:18 · 207 阅读 · 1 评论