随笔分类 -  sql

mybatis 默认插入当前时间
摘要：<insert id="importSickTree" parameterType="list" > insert into tb_sick_tree (treeCode,projectID, lat, lon, distCode, distName, identifyTime,processed, 阅读全文
posted @ 2021-01-08 10:48 菜鸟也想飞上天 阅读(8198) 评论(0) 推荐(0)
mysql 列转行 动态写法
摘要：INSERT INTO `tb_score` VALUES ('1', '001', '语文', '90'); INSERT INTO `tb_score` VALUES ('2', '001', '数学', '92'); INSERT INTO `tb_score` VALUES ('3', '0 阅读全文
posted @ 2019-11-01 16:15 菜鸟也想飞上天 阅读(4518) 评论(0) 推荐(2)