Closed
Description
版本号:
<dependency>
<groupId>org.jeecgframework.boot</groupId>
<artifactId>codegenerate</artifactId>
<version>1.0.8</version>
</dependency>
问题描述:
查询 information_schema.columns
在Mysql8中,查询出来没有按照设置的排序顺序
select column_name,data_type,column_comment,numeric_precision,numeric_scale,character_maximum_length,is_nullable nullable from information_schema.columns where table_name = '' and table_schema = ''
解决方式: 在查询的后面增加 order by ORDINAL_POSITION
select column_name,data_type,column_comment,numeric_precision,numeric_scale,character_maximum_length,is_nullable nullable from information_schema.columns where table_name = '' and table_schema = '' order by ORDINAL_POSITION
Activity
zhangdaiscott commentedon Dec 29, 2019
好的
zhangdaiscott commentedon Dec 30, 2019
已经修改升级jar即可