Bulk data Insert in Mysql from txt file

Command:

- load data infile 'demo1.txt' into table demo fields terminated by ',' ;

   ...here demo is table name

Txt File- demo.txt

vishal,
ram,
rohit,
smita


Store file at var/lib/mysql/your_DB_Name/demo.txt
---------------------------------------------------