shmily138的博客

安装mysql sudo apt-get install mysql-server sudo apt-get install mysql-client sudo apt-get install libmysqlclient-dev sudo apt-get install libmysqlcppconn-dev sudo apt-get install qtbase5-private-dev qmake “INCLUDEPATH+=/usr/include/mysql” “LIBS+=-L/usr/lib/

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