Flipkart

Wednesday, July 15, 2009

Mysql: Exporting and Importing Dat

mysql> --local-infile=1

'''Exporting Data'''

SELECT
FROM
INTO OUTFILE '/tmp/vworks/sample.txt'

'''Importing data'''


LOAD DATA INFILE 'file_name.txt'
INTO TABLE tbl_name (field1, field2...etc)

No comments:

Post a Comment