2021年5月24日
mybatis中foreach collection三种用法
摘要： mybatis中foreach collection三种用法 https://cloud.tencent.com/developer/article/1644999 阅读全文
posted @ 2021-05-24 20:26 tonggc1668 阅读(81) 评论(0) 推荐(0)
mysql按分隔符输出多行
摘要： SELECT DISTINCT substring_index(substring_index(a.value, '\n', b.help_topic_id + 1), '\n',- 1) NAMEFROM t_cr_permission a JOIN mysql.help_topic b ON b 阅读全文
posted @ 2021-05-24 05:43 tonggc1668 阅读(210) 评论(0) 推荐(0)
mysql DATETIME
摘要： set @report_date = '2013-01-17 00:00:00';select @report_date; set @report_date = cast('2013-01-17 00:00:00' as datetime); SELECT @report_date; DECLARE 阅读全文
posted @ 2021-05-24 03:22 tonggc1668 阅读(92) 评论(0) 推荐(0)