随笔分类 - mysql
mysql
摘要：select (select count(business_status) from business_express a where business_status='TS' ) as TS, + (select count(business_status) from business_expre
阅读全文
摘要：select username,count(*) as count from hk_test group by username having count>1;
阅读全文
摘要：一张test表里存了一个content字段是json类型的，查询该content里manualNo这个字段 select JSON_EXTRACT (test .content, '$.manualNo') from test 博主微信xjt199561,欢迎技术交流。
阅读全文
摘要：CREATE DEFINER=`wpsuper`@`%` TRIGGER `o2oinsert` BEFORE INSERT ON `t_s_o2o`FOR EACH ROW begin set New.fbianhao=(select fprojectval from t_billCodeRule
阅读全文
摘要：这里登陆的是mysql3308端口号的数据库 mysql -P3308 -p用户名 -u密码
阅读全文
