HuyPV
Saturday, December 22, 2012
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;
Title:
Import mysql data
Description:
Table voucher(id INT, code CHAR(7), created INT) code = 0000000 - 9999999 Option 1: File /home/huypv/shop/data.sql INSERT INTO #5K rec...
...
Rating:
4