Help me format this statement
- Date: Tue, 11 Mar 2008 16:14:46 -0700
- From: Brian Dunning <brian@xxxxxxxxxxxxxxxx>
- Subject: Help me format this statement
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx
- Follow-Ups:
- Re: Help me format this statement
- From: wim . delvaux
- Re: Help me format this statement
- Prev by Date: lock write and sql_cache
- Next by Date: Re: Help me format this statement
- Previous by thread: lock write and sql_cache
- Next by thread: Re: Help me format this statement
- Index(es):