RE: copying data!!!

["Gordon Bruce" <suppressed>]

Sorry the DROP TABLE Should be TEMP not table1

-----Original Message-----
From: Gordon Bruce [mailto:suppressed 
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; suppressed
Cc: suppressed
Subject: RE: copying data!!!

This is kind of ugly, but with the multitable limitations of 3.23 it
probably works.

CREATE TABLE TEMP 
SELECT table_1 columns except age, table_2 age
FROM   table_1 
       INNER JOIN table_2 
       USING (name);
TRUNCATE table_1; 

INSERT INTO table_1 
SELECT * 
FROM TEMP; 

DROP TABLE_1;



-----Original Message-----
From: Sachin Bhugra [mailto:suppressed 
Sent: Friday, December 09, 2005 3:00 PM
To: suppressed
Cc: suppressed
Subject: Re: copying data!!!

Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but believe me i am tryin this for
past three days and not able to get it)

Pls hlp..(just give me hint in right direction, and i will try to do
the rest....)

Tnx
Sachin

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/suppressed




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/suppressed




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed