Import mysql data

Table voucher(id INT, code CHAR(7), created INT)
code = 0000000 - 9999999

Option 1: File /home/huypv/shop/data.sql
INSERT INTO #5K records/line
INSERT INTO
mysql -uhuypv -p shop
source /home/huypv/shop/data.sql

Option 2 (faster than option 1): File /home/huypv/shop/data.txt
1 [TAB] 0001000 [TAB] 1356146464
2 [TAB] 0347711 [TAB] 1356146464
mysql -uhuypv -p shop
LOAD DATA INFILE "/home/huypv/shop/data.txt" INTO TABLE voucher;