post icon

How to copy selected fields from one table to another table in MySQL?

SQL command to copy filed(s) from first table (here “single”) to second table “bank” in field “bankname”.

INSERT INTO `bank` (`bankname`) SELECT distinct `bank` FROM `single`

Comments are closed.

Leave a comment