SQL
SQL
mazhongjia
这个作者很懒,什么都没留下…
展开
-
sql之left join、right join、inner join的区别
union、union all的区别跳转https://www.cnblogs.com/logon/p/3748020.htmlSQL JOINS:Please refer the link :https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins如图:left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录right join(右联接) 返回包括...转载 2020-08-19 17:40:06 · 97 阅读 · 0 评论 -
Navicat 导出导入数据库
https://blog.csdn.net/qq_21808961/article/details/80899928转载 2020-06-20 16:26:47 · 132 阅读 · 0 评论 -
SQL中order by里面可以加条件
下面实现:ID列放在最前面,其他列按照null_flag desc进行排序select table_id, COLUMN_NAME_ENG, null_flag,Mdms_flag from sys_column_info where TABLE_ID='407' and Mdms_flag = 1ORDER BY case WHEN COLUMN_NAME_ENG <> 'id' THEN 1 ELSE 0 END, null_flag desc...原创 2020-06-16 17:28:06 · 4599 阅读 · 0 评论