Re: insert syntax
| From: | Andrei BEJENARU | Date: | Tue, 25 Nov 2003 14:30:51 +0000 |
| Subject: | Re: insert syntax | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-22186@lists.php.net to get a copy of this message | ||
Hi,
In MySQL it's INSERT INTO table2 SELECT * FROM table1
Regards,
Andrei
"Rinku Shivnani" <rinku@banas.guj.nic.in> wrote in message
news:3FC390F0.4643.1634C70@localhost...
> Dear All,
>
> I want to insert data from one table to another one. But I don't
> remember the syntax properly. Can you pls help me ?
>
> Insert into tablename2 as select * from tablename1
>
>
> Thank you.