Mysql
Kayla1363
这个作者很懒,什么都没留下…
展开
-
EXPLAIN Statement
Reference:https://dev.mysql.com/doc/refman/8.0/en/explain.htmlhttps://dev.mysql.com/doc/refman/8.0/en/explain-output.html1、Obtaining Table Structure InformationDESCRIBE|EXPLAIN order_tm_order...原创 2019-12-11 11:57:30 · 316 阅读 · 0 评论 -
COALESCE函数使用
COALESCE(value,...)Returns the first non-NULL value in the list, or NULL if there are no non-NULL values.例子1:基础使用mysql> SELECT COALESCE(NULL,1); -> 1mysql> SELECT COALESCE(NUL...原创 2019-11-29 15:29:21 · 461 阅读 · 0 评论 -
UNION的使用
UNION is used to combine the result from multiple SELECT statements into a single result set.The column names from the first SELECT statement are used as the column names for the results returned. S...原创 2019-11-28 18:03:55 · 198 阅读 · 0 评论