INSERT SELECT and VALUES

Hi All I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values to this and so some thing like. INSERT INTO table1 SELECT table2 VALUES ('A','B'); But I can not find if this can be done or

Re: INSERT SELECT and VALUES

PROTECTED] To: 'Mysql (E-mail)' [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 3:51 PM Subject: INSERT SELECT and VALUES Hi All I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values

Re: INSERT SELECT and VALUES

Simon, Thursday, July 18, 2002, 1:21:20 PM, you wrote: I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values to this and so some thing like. INSERT INTO table1 SELECT table2 VALUES ('A','B');

INSERT ... SELECT and VALUES? Is this possible?

I have a table(2) with a different structure than the table(1) I'm selecting from. I want to be able to grab some info from table1, put it in table2, along with some variables from my php page. Is it possible to do like: INSERT INTO table2 VALUES 1,2,3 SELECT 4,5,6 FROM table1 Or do I need to

Re: INSERT ... SELECT and VALUES? Is this possible?

At 4:51 PM -0700 10/31/01, Nathan wrote: I have a table(2) with a different structure than the table(1) I'm selecting from. I want to be able to grab some info from table1, put it in table2, along with some variables from my php page. Is it possible to do like: INSERT INTO table2 VALUES 1,2,3