List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:May 24 2000 1:38pm
Subject:Re: Copy a column from one table to another
View as plain text  
Rahim Vaseghi writes:
 > Does anyone know how to copy a column or some columns from a table to another.
 > 
 > Regards,
 > Rahim Vaseghi
 > 


Try 

INSERT INTO table (field1,field2,..) SELECT field1,field2.. from
table2 WHERE .........


Regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
Copy a column from one table to anotherRahim Vaseghi24 May
  • Re: Copy a column from one table to anothersinisa24 May