From the command line What is the syntax syntax to import some data into mysql table

Glenn D. · 03-13-2015, 09:13 AM

Hello
From the command line [linux], What is the command syntax to import some data into a mysql table ?

Using linux.
# which mysql
/usr/bin/mysql

The table has 20 columns in it.
The data file has about 900 rows in it
The data file a CSV file comma ',' seperated fields.
Thank you.
--Glenn

TenTenths · 03-13-2015, 09:26 AM

Code:

mysql -u username -p password -e "query to execute" dbname

As for the actual query http://dev.mysql.com/doc/refman/5.6/en/load-data.html