tCreateTable and auto_increment

One Star

tCreateTable and auto_increment

Hello every body
I looking for creating a table in MySQL RDMS with a auto_increment column.
I think that tCreateTable component is a good choice, but this option is not available.
Thank you for all ideas.
Best regards
Max
One Star

Re: tCreateTable and auto_increment

Hi,
Did you try tMySqlRow with your specific SQL, for example:
CREATE TABLE employes (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);

Regards,
Youssef
One Star

Re: tCreateTable and auto_increment

Thank you very much Youssef, it's simple.
I never use this component.
In the future I think mostly use it.
Best regards
Max