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);
Comments
0 comments
Please sign in to leave a comment.