How to use the "LOAD DATA INFILE" command?

0

I have a database and I have a table called "people" which contains "people_id" as an attribute and I want to test how to import information using this title command, I have already saved an excel file in the format ".csv" as follows:

link : In this article the author teaches to use but it does not make clear how to indicate the path where the file is, could someone give a help and explain me the parameters?

    
asked by anonymous 12.12.2017 / 18:19

1 answer

1

I was able to use the command like this:

  

LOAD DATA LOCAL INFILE 'C: Users / Wallace / Desktop / activity / data.txt' INTO TABLE people;

    
12.12.2017 / 18:45