Exporting Data : Import Export Data « MySQL Utilities « MySQL Tutorial

MySQL Tutorial 1.  Introduction 2.  Select Query 3.  Database 4.  Table 5.  Table Join 6.  Subquery 7.  Insert Update Delete 8.  Logic Operator 9.  View 10.  Data Types 11.  Procedure Function 12.  Cursor 13.  Trigger 14.  Date Time Functions 15.  Comparison Functions Operators 16.  Aggregate Functions 17.  Cast Functions Operators 18.  Control Flow Functions 19.  Encryption Compression Functions 20.  Information Functions 21.  Math Numeric Functions 22.  Miscellaneous Functions 23.  String Functions 24.  Regular Expressions 25.  Data Dictionary 26.  MySQL Utilities 27.  Privilege Microsoft Office Word 2007 Tutorial Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL VB.Net VB.Net Tutorial

MySQL Tutorial » MySQL Utilities » Import Export Data   26. 2. 2. Exporting Data The command to export data to a text file is similar to the standard SELECT command. MySQL creates a 'tab delimited' file by default.    SELECT <columns> FROM <table_name> INTO OUTFILE <file_name>      SELECT employee.id, employee.first_name, employee.last_name, employee.start_date, employee.salary, employee.city FROM employee INTO OUTFILE 'c:\\employee.txt';          26. 2. Import Export Data 26. 2. 1.  Turn Exporting and Importing Data on 26. 2. 2.  Exporting Data 26. 2. 3.  Importing data 26. 2. 4.  Load data to your table 26. 2. 5.  LOAD DATA INFILE into a table

ww__w.___ja_v__a___2__s___._c___om__ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.