Copying data between tables using Mysql

Posted: 23 października 2011 in Bazy danych, LAMP, MySql, SQL
Tagi: , , ,

Copying data between tables:

 

INSERT INTO table SELECT * FROM base2.table;


Copying data between tables including fields list:

 

INSTER INTO client (client_id, word) SELECT 4, word FROM client WHERE client_id = 3;


Dodaj komentarz