随笔分类 -  mysql

摘要:select user_id,name,((select count(1) from sys_user_1 A where A.user_id = B.user_id)) from sys_user b where (select count(1) from sys_user_1 A where A 阅读全文
posted @ 2019-08-22 17:45 小农_码 阅读(292) 评论(0) 推荐(0)
摘要:SELECT date_format(( now() + INTERVAL -( 11 ) MONTH ), '%Y年%m月' ) AS `months` UNIONSELECT date_format(( now() + INTERVAL -( 10 ) MONTH ), '%Y年%m月' ) A 阅读全文
posted @ 2019-06-06 16:06 小农_码 阅读(208) 评论(0) 推荐(0)