MySQL :: INSERT .... SELECT COMMAND

Hi Experts, mysql> CREATE TABLE table1(id INTEGER AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100)); Query OK, 0 rows affected (0.04 sec) mysql> CREATE TABLE table2(id INTEGER AUTO_INCREMENT PRIMARY KEY,table1id INTEGER ...

forums.mysql.com