Faruq Codes
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment