I have a somewhat curious problem, maybe a challenge.
I need to add to my database the list of all cities in Brazil, I found a SQL with all the way I need it, however, the name of the SQL table is with "quotation marks" as in the following example:
INSERT INTO 'tb_cidades' VALUES (0001, 01, 'AC', 'Acrelandia');
INSERT INTO 'tb_cidades' VALUES (0002, 01, 'AC', 'Assis Brasil');
INSERT INTO 'tb_cidades' VALUES (0003, 01, 'AC', 'Brasileia');
INSERT INTO 'tb_cidades' VALUES (0004, 01, 'AC', 'Bujari');
INSERT INTO 'tb_cidades' VALUES (0005, 01, 'AC', 'Capixaba');
I would like to know, as I do to create a simple script or algorithm, to change the name 'tb_cidades' to cities. I have the list with all, only in a .txt file