
mysql
liu_zhaoming
从事 java开发工作
展开
-
The getKey method should only be used when a single key is returned
问题 mysql 正常, h2 出现 The getKey method should only be used when a single key is returned 更改前 @Override public long insertNew(ProduceMessage message) { KeyHolder holder = new GeneratedKeyHolder(); String json = this.gson.toJson(message.get原创 2020-07-31 15:37:11 · 1111 阅读 · 0 评论 -
查询某个数据库中某个表的所有列名
1. 查询某个数据库中某个表的所有列名 SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'tb_name'; 2. 查询某个数据库中某个表的所有列名,并用逗号连接 SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS WHERE TABLE_SCHEMA原创 2020-07-01 10:56:04 · 1961 阅读 · 0 评论