topic Re: tCreateTable and auto_increment in Talend Studio

tCreateTable and auto_increment

Anonymous — Sat, 16 Nov 2024 14:07:14 GMT

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

Re: tCreateTable and auto_increment

youssef2 — Tue, 16 Dec 2008 15:13:18 GMT

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

Re: tCreateTable and auto_increment

Anonymous — Tue, 16 Dec 2008 16:11:23 GMT

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