25 Aug
2009
25 Aug
'09
12:31 p.m.
Is there some way in S-SQL to generate INSERT INTO clauses with multiple rows, e.g. "INSERT INTO "table" (a, b) VALUES (10, 20), (30, 40)" ? Desired sexp format is `(:insert-into table :set a (10 20) b (30 40)),
The functionality already exists, albeit undocumented.
(:insert-rows-into 'table :columns 'a 'b :values '((10 20) (30 40)))
-- Daniel White
Thanks, Daniel!
--
Timur Sufiev