![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 982 阅读 · 0 评论 -
查询某个数据库中某个表的所有列名
1. 查询某个数据库中某个表的所有列名SELECT COLUMN_NAME FROM information_schema.COLUMNSWHERE 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 · 1884 阅读 · 0 评论