Monday, June 8, 2009

mysal data load and unload

SELECT * INTO OUTFILE 't1.txt' FIELDS ENCLOSED BY '0' FROM t1;

LOAD DATA INFILE 'LEVEL4.TXT' INTO TABLE HSBC_LEVEL4 FIELDS ENCLOSED BY '|';

No comments:

Post a Comment