Mustang Internet Services Knowledge Base Glossary    Contact Us
  Return to MustangInternetServices.com Home Page
Search  
   
Browse by Category
Mustang Internet Services Knowledge Base
 Mail & DNS.
 Misc.
 MySQL
 Working With Files
 PHP
 System Administration
 Terms, Conditions, Policies, FAQs, Etc.
 Windows
Mustang Internet Services Knowledge Base .: MySQL .: Working With Files .: Load Data From File Into Table

Load Data From File Into Table

 Example syntax to load CSV file:

LOAD DATA INFILE '/home/jr/tableInfo.txt' INTO TABLE workingTable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
Article 004
Created 2-11-2005
Author mustang
Rating

How helpful was this article to you?

Related Articles

article Exporting A Table To A CSV Text File
Example of how to export a table to a CSV text...
(No rating)  10-4-2005    Views: 2317   

User Comments

Add Comment
No comments have been posted.


.: Powered by Lore 1.5.2
(c) 2004-2005, Mustang Internet Services, Inc.