![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
Kayla1363
这个作者很懒,什么都没留下…
展开
-
EXPLAIN Statement
Reference: https://dev.mysql.com/doc/refman/8.0/en/explain.html https://dev.mysql.com/doc/refman/8.0/en/explain-output.html 1、Obtaining Table Structure Information DESCRIBE|EXPLAIN order_tm_order...原创 2019-12-11 11:57:30 · 307 阅读 · 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); -> 1 mysql> SELECT COALESCE(NUL...原创 2019-11-29 15:29:21 · 457 阅读 · 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 · 196 阅读 · 0 评论