How do I get autoincrement to generate in MYSQL?

Updated February 22, 2017 17:58

I want to generate AUTO_INCREMENT on my integer columns in MYSQL database. How do I do that?

Solution:

First, please pick the domain Number to get the datatype INTEGER.

Or just change the Physical Data Type to INTEGER.

Then, check on Generated Identity on the Columns editor | MySQL tab.

Here is the resultant SQL the Forward Engineer produces:

CREATE TABLE E_1
(
a INTEGER NOT NULL AUTO_INCREMENT
);

ALTER TABLE E_1
ADD CONSTRAINT XPKE_1 PRIMARY KEY (a);

0 comments

Please sign in to leave a comment.