MySQL and SQL Server

SQL Server and MySQL DBA.

Friday, 25 October 2013

MySQL export table to csv file

SELECT id, table_id, indices,create_time
INTO OUTFILE '/usr/local/mysql/tblTest.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM tblTest WHERE 1;
Posted by Unknown at 00:42
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2018 (1)
    • ►  October (1)
  • ►  2017 (4)
    • ►  July (1)
    • ►  April (3)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2015 (10)
    • ►  December (1)
    • ►  November (1)
    • ►  September (2)
    • ►  August (3)
    • ►  July (1)
    • ►  April (1)
    • ►  January (1)
  • ►  2014 (11)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (2)
    • ►  April (2)
    • ►  March (2)
    • ►  January (1)
  • ▼  2013 (23)
    • ►  December (1)
    • ►  November (2)
    • ▼  October (3)
      • MySQL export table to csv file
      • CENTOS install rlwrap for oracle sqlplus
      • MySQL NDB Cluster Configuration Step by Step
    • ►  September (3)
    • ►  August (5)
    • ►  July (9)

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.