Using ExecuteSQL script step for multiple queries

[carl9861]

I'm trying to prefix a unique serial number (generated in x1 MySQL table) with a text string (in another MySQL table) and zerofill the integer so that the VARCHAR is 13 characters in length - via the use of the ExecuteSQL script step.

In MySQL I can create the serial number (ID in serial table), get the LAST_INSERT_ID() in that table and then pass the value across to the second table

serial table;

serialID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

PRIMARY KEY (serialID)

products table;

serialID INT(9) UNSIGNED ZEROFILL NOT NULL

productID VARCHAR(13)

PRIMARY KEY (serialID)

Query example;

INSERT INTO serial (serialID) VALUES (NULL);

INSERT INTO products (serialID, productID) VALUES (LAST_INSERT_ID(), CONCAT('PROD',serialID));

Question: How can I re-create this using FP12?