INSERT INTO phonebook VALUES('01', 'John', 'Doe', 'North America')
I have a table of records and it is A LOT. Inserting it one by one through phpMyadmin is a tedious job. I was thinking maybe there would be an excel formula for it where every word after commas are replaced. So I cant just copy the codes then run it on sql.