Zongji is mixing up the column names

[blaart]

The query that is used for mapping the columns is mixing up the order of the columns. (Mysql v8.0) Please add 'ORDER BY ORDINAL_POSITION' to the query to fix this. (Worked for me..)
Like:
var tableInfoQueryTemplate = 'SELECT ' +
'COLUMN_NAME, COLLATION_NAME, CHARACTER_SET_NAME, ' +
'COLUMN_COMMENT, COLUMN_TYPE ' +
'FROM information_schema.columns ' + "WHERE table_schema='%s' AND table_name='%s'" +
'ORDER BY ORDINAL_POSITION';

[rodrigogs]

You can use my fork: https://github.com/rodrigogs/zongji

I solved a lot of bugs

[blaart]

You can use my fork: https://github.com/rodrigogs/zongji

I solved a lot of bugs

Thanks!!

[ralexandr]

Fixed in PR #129