mysqlimport csv

1C:\mysql\bin>mysqlimport --ignore-lines=1 --fields-terminated-by=, --verbose --local -u root query C:/mysql/bin/mysql-files/address.csv
2
3Connecting to localhost
4
5Selecting database query
6
7Loading data from LOCAL file: C:/mysql/bin/mysql-files/address.csv into address
8
9query.address: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
10Disconnecting from localhost
11
12mysql> Select * from Address;
13+---------+----------+-------------+
14| Name    | LastName | Address     |
15+---------+----------+-------------+
16| Mohan   | Sharma   | Sundernagar |
17| Saurabh | Arora    | Chandigarh  |
18| Rajesh  | Singh    | Lucknow     |
19+---------+----------+-------------+
203 rows in set (0.00 sec)