Re: [GENERAL] INSERTS and Queries
On Mon, 01 Mar 2004 13:36:35 +, C G <[EMAIL PROTECTED]> wrote: Dear All, I can use insert with 'select' if I do this INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2; But I want to insert more than one thing into the table, e.g. INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100; Any ideas on how I would achieve this? INSERT INTO TABLE t1 (col1,col2) SELECT stuff, 100 FROM t2; Thanks Colin _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] INSERTS and Queries
C G wrote: Dear All, I can use insert with 'select' if I do this INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2; But I want to insert more than one thing into the table, e.g. INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100; Any ideas on how I would achieve this? Thanks Colin _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger ---(end of broadcast)--- TIP 8: explain analyze is your friend The SELECT clause can be any ordinary SELECT clause, that can return multiple columns from a table. So for example: INSERT INTO table (col1, col2) SELECT col1, col2 from table2; Also, just like standard SELECT statements, the following would also work: INSERT INTO table (col1, col2) SELECT col1, 100 FROM table2; HTH Nick ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] INSERTS and Queries
Dear All, I can use insert with 'select' if I do this INSERT INTO TABLE t1 (col1) SELECT stuff FROM t2; But I want to insert more than one thing into the table, e.g. INSERT INTO TABLE t1 (col1,col2) SELECT stuff FROM t2 , 100; Any ideas on how I would achieve this? Thanks Colin _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger ---(end of broadcast)--- TIP 8: explain analyze is your friend