![]() This process is working well for me so far (and I am not looking for another way to do this). LOAD DATA INFILE SQL para importar CSV a MySQL. ![]() But I couldn't find a way out with the mysql LOAD DATA INFILE command.I needed to transfer data from MSSQL (Microsoft SQL Server) to MySQL, and the best option for me was to write a python script that exported data as csv from MSSQL and then import this csv into mysql. You can use the LOAD DATA INFILE command to import a CSV file into a table. ![]() ![]() Although the examples are fairly basic, they demonstrate the fundamental components that go into a LOAD DATA statement and some of the issues you might run up against along the way. One is to use a command line tool and another is to use a Graphical User Interface, or GUI. In this article, I show how to use the LOAD DATA statement to add data from comma-separated values (CSV) files and other plain text files. 2) SQL Server: Import CSV files to MSSQL with no problem no major. MySQL
0 Comments
Leave a Reply. |