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;
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;