mysql copy

[Anon]

Which is the command in MySql for copying one row n from a table1 to a table2 ?

(Having the two tables the same fields.)

Thanks

Kante

[[deleted]]

Manuals are your friends, read them.

INSERT INTO table2 (field1,field2,field3) SELECT (field1,field2,field3) FROM table1;

[jariizumi]

Manuals may be, but so is phpMyAdmin 😉 This job can be done with just typing in a name and a few clicks, whereas you have to create a table by describe table1 and create able2 before you can copy with that approach. But sometimes, the extra typing is safe and reliable... it's your call.

[[deleted]]

phpMyAdmin is nice, but it doesn't teach you how to do it in the database.
Suppose I want to copy tables from within a PHP script? 🙂