![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
shmily138
暂缺
展开
-
ubuntu qt mysql 源码编译
安装mysqlsudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install libmysqlclient-devsudo apt-get install libmysqlcppconn-devsudo apt-get install qtbase5-private-devqmake “INCLUDEPATH+=/usr/include/mysql” “LIBS+=-L/usr/lib/原创 2020-06-08 10:23:12 · 316 阅读 · 1 评论 -
mysql left join 空值改默认值 coalesce
select A.*,coalesce(B.bEnable,0) as bEnable from data_dictionary A left join role_auth B on A.sCode=B.sAuthCode and B.sRoleCode=‘001’ where A.iType=1原创 2020-06-02 17:26:38 · 1951 阅读 · 0 评论