Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Have not seen any problems in this area. With localhost:

image description

using:

image description

Hello,

Have not seen any problems in this area. With localhost:

image description

using:

image description

Edit 2018-08-20:

Have done some further testing on this. JRE does not seem to be a concern. Have tries with various connectors under JDK-10, Open JDK 1.8.0_181, JRE 1.8.0_102 and others.

Creating a NEW table with an auto increment field was no problem using a variety of connectors (including mysql-connector-java-8.0.12.jar).

Copying a table with an auto increment field worked with mysql-connector-java-5.1.42.jar but dropped the auto increment using mysql-connector-java-8.0.12.jar.

When modifying an EXISTING table with auto increment set to NO, none of the connectors would allow resetting to YES using the GUI. HOWEVER, this can be reset from the main screen menu Tools->SQL with:

ALTER TABLE `Table_Name` CHANGE COLUMN `ID` `ID` INT(10) NOT NULL AUTO_INCREMENT ;

where ID is the field name to contain the auto increment.

Certainly appears to be a connector problem in the copy process but not certain exactly where the problem lies with changing the auto increment from NO to YES. Could be either the connector or Base.