Page MenuHomePhabricator
Authored By
stwalkerster
May 23 2019, 11:13 PM
Size
368 B
Referenced Files
None
Subscribers
None
select replace(s.vsql, '$$ID$$', r.id) from request r
cross join (
select 'INSERT INTO log (objectid, objecttype, user, action, timestamp) VALUES ($$ID$$, ''Request'', 7, ''Deferred to users'', current_timestamp());' as vsql from dual
union all select 'UPDATE request SET status = ''Open'', reserved = 0 WHERE id = $$ID$$;' from dual
) s where r.id in (1,2,3,4,5,6,7);

File Metadata

Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
133966
Default Alt Text
raw.txt (368 B)

Event Timeline