Sorry the DROP TABLE Should be TEMP not table1
-----Original Message-----
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:00 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
