INSERT SELECT

113 views

Skip to first unread message

unread,

Mar 20, 2007, 3:12:30 PM3/20/07

to H2 Database

Will something like the following SQL idiom work on H2:

INSERT california_authors (au_id, au_lname, au_fname)
SELECT au_id, au_lname, au_fname
FROM authors
WHERE State = 'CA'

unread,

Mar 21, 2007, 1:10:17 AM3/21/07

to h2-da...@googlegroups.com

Hi,
Yes, this syntax is supported (see also the grammar docs).
Thomas

Reply all

Reply to author

Forward

0 new messages