Server Action to Copy A Table Row

[Antony]

@TomD

CREATE TEMPORARY TABLE tmptable_1 SELECT * FROM myTable WHERE id = 100;
ALTER TABLE tmptable_1 MODIFY id int(12) null;
UPDATE tmptable_1 SET id = NULL;
INSERT INTO myTable SELECT * FROM tmptable_1;
DROP TEMPORARY TABLE IF EXISTS tmptable_1;

Well on the assumption that Wappler is to be easy to use as a low/no code solution, I'm not convinced that the above really fits that requirement!