12 2019 档案

摘要:一、mybatis SQL的批量操作 1>,批量插入 简单语法: insert into table (字段一,字段二,字段三) values(xx,xx,xx),(oo,oo,oo) 示例: <insert id="insertBatch" parameterType="java.util.Lis 阅读全文
posted @ 2019-12-24 11:16 404UnknownCoder 阅读(310) 评论(0) 推荐(0)
摘要:1,springboot 启动时报错: *************************** APPLICATION FAILED TO START *************************** Description: Parameter 0 of method testService 阅读全文
posted @ 2019-12-19 11:42 404UnknownCoder 阅读(166) 评论(0) 推荐(0)
摘要:1,查询表中所有字段(横排): SELECT GROUP_CONCAT( COLUMN_NAME SEPARATOR "," ) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '数据库名' AND TABLE_NAME = '表名' 阅读全文
posted @ 2019-12-18 09:02 404UnknownCoder 阅读(488) 评论(0) 推荐(0)
摘要:显示: SELECT a.uuid AS user_organ_relate_uuid, b.org_code, b.org_name, b.org_type, c.user_id, c.user_name FROM t_user_organ_relate a INNER JOIN t_organ 阅读全文
posted @ 2019-12-10 09:30 404UnknownCoder 阅读(248) 评论(0) 推荐(0)