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
>> VA
essage -
From: "Simon Green" <[EMAIL 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 u
> 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 d
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
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
