Skip to content

使用JeecgOneGUI 在MySQL8 代码生成,实体内的顺序不一致和表设置顺序不一致 #839

Closed
@emmetmayi

Description

@emmetmayi
版本号:
<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
截图&代码:

image

image

Activity

zhangdaiscott

zhangdaiscott commented on Dec 29, 2019

@zhangdaiscott
Member

好的

zhangdaiscott

zhangdaiscott commented on Dec 30, 2019

@zhangdaiscott
Member

已经修改升级jar即可

  <dependency>
  <groupId>org.jeecgframework.boot</groupId>
  <artifactId>codegenerate</artifactId>
  <version>1.0.9</version>
</dependency>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @zhangdaiscott@emmetmayi

        Issue actions

          使用JeecgOneGUI 在MySQL8 代码生成,实体内的顺序不一致和表设置顺序不一致 · Issue #839 · jeecgboot/JeecgBoot