On Wednesday 12 March 2008 00:14:46 Brian Dunning wrote:
> I am an idiot. table_a and table_b have exactly the same structure.
> How do I say this in SQL:
>
> INSERT (all records from table_a) into table_b where table_a.customer
> = '12'
>
> Just trying to eventually duplicate the whole table, one
Thanks to everyone who replied. So simple I couldn't see it. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am an idiot. table_a and table_b have exactly the same structure.
How do I say this in SQL:
INSERT (all records from table_a) into table_b where table_a.customer
= '12'
Just trying to eventually duplicate the whole table, one customer's
set of records at a time. Thanks.
--
MySQL Gener
