How to add many clients at once in a database table?

Navigation
0

I need to add Name, Phone and Address of many clients that are in excel and pass this to the database. What would be the quickest way to do this?

    
asked by anonymous 07.03.2017 / 21:48

1 answer

0

Exporting to CSV you can use HeidiSQL to import as in this question answered link

or use the MySQL LOAD DATA command described in the documentation link

Just be careful with one detail: because of the numbering, Excel exports CSV not seperated by comma, but by a semicolon.

    
07.03.2017 / 22:15
How to write the fetch result to a txt and then download it? Attempt to manipulate values of a vector generated by a JSON