You are not logged in.
Thanks for the description. It works perfect!
The default storage engine can be changed at server startup or at runtime:
* The default storage engine can be specified at server startup with the --default-storage-engine option.
* For a running server, an administrator who has the SUPER privilege can change the default storage engine globally for all clients by setting the global storage_engine system variable:
SET GLOBAL storage_engine = engine_name;
Setting the storage engine this way affects any client that connects after the statement executes. Clients that are connected at the time of statement execution are unaffected.
* Any client can change its own default storage engine by issuing either of these statements:
SET SESSION storage_engine = engine_name;
SET storage_engine = engine_name;
In talend, you can use tMysqlRow to execute a sql statement and change the storage engine at the runtime before tCreateTable.
"SET SESSION storage_engine = InnoDB"
I would like to create a MySql table that uses the InnoDB engine and not the default engine MyISAM.
Currently I don't see a way to do this using the tCreateTable component.