1
I am creating a table in Mysql, in it I will import daily several CSV files with different names.
When importing I need the file name to turn a column in the table.
Teste1.csv:
111111;HONORIO;20
22222;PEDRO;30
Teste2.csv:
33333;ROBSON;10
44444;JOAO;05
I need importing into Mysql to look like this:
Teste1;111111;HONORIO;20
Teste1;22222;PEDRO;30
Teste2;33333;ROBSON;10
Teste2;44444;JOAO;05
Do you know how you will import files with different names? Do not think it is worth creating a macro in excel that reads the file inserts a column with the file name and renames the file and fires the command in mysql?
– Heitor Scalabrini