#####Mysql当查询为空设置默认值: 查询某个字段为空,并设置默认值 IFNULL(name,"你好") COALESCE(name,"你好") #####Mysql多表组合: A,B两表数据组合在一起,字段不同可以通过AS统一 SELECT * FROM A UNION SELECT * FROM B #####Mysql查询加入字段: SELECT '你好' AS name FROM A
转载于:https://my.oschina.net/u/2546235/blog/1921447