I need to copy all rows from table1 matching specific columns into table2 with different columns name. For example:
Data in columns "Name,Surname,Number" in "oldAddressBook" must fill respectively "newName,newSurname,Phone" in "newAddressBook". "oldAddressBook" and "newAddressBook" contain also other columns.
INSERT INTO newAddressBook (newName, newSurname, Phone)
SELECT name, surname, number
FROM oldAddressBook
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With