I have a excel table, the first rows called ID, the ID of each line 1 at a time, such as the first line ID is 1, the second row ID is 2, the third line ID is 3... . Now I through navicat speak this excel import into a mysql database, query the table from the data, order ID the result of the inconsistent, as shown in the figure below, please help to see is there any way to avoid the occurrence of this

CodePudding user response:

The order by id

CodePudding user response:

good good...

CodePudding user response:

The building Lord will excel in the ID column to digital type

CodePudding user response:

The ID column is character?

CodePudding user response:

references 4 floor selling fruit net reply:

ID column is character?

yeah garage should use the int type.