how to prepare csv file for mysqlimport code example
Example: mysqlimport csv
C:\mysql\bin>mysqlimport
Connecting to localhost
Selecting database query
Loading data from LOCAL file: C:/mysql/bin/mysql-files/address.csv into address
query.address: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
Disconnecting from localhost
mysql> Select * from Address;
+
| Name | LastName | Address |
+
| Mohan | Sharma | Sundernagar |
| Saurabh | Arora | Chandigarh |
| Rajesh | Singh | Lucknow |
+
3 rows in set (0.00 sec)