Tuesday, November 6, 2012

export in mysql

1. export in mysql in txt file 

SELECT * FROM  MyTable INTO OUTFILE  'C:\\FileName.txt' 

2.  export in mysql in csv file 

SELECT * FROM table1  INTO OUTFILE 'c:///mytable.csv' FIELDS ESCAPED BY '""' TERMINATED 
BY ','  ENCLOSED BY '"' LINES TERMINATED BY '\r\n' 

3. . export in mysql in excel file


No comments:

Post a Comment

If you Satisfied , Please Leave a comment