MySql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dave_c00
Forum Commoner
Posts: 37
Joined: Wed May 28, 2003 6:08 am

MySql

Post by dave_c00 »

Hi,

I have connection to a server and have created a database on that server. Now i wish to make a table in MySql and populate it with a text file of data. I know to make the table using CREATE but how do i feed the text file into it?? Can anyone help me with this??

Thanks

Dave
User avatar
daven
Forum Contributor
Posts: 332
Joined: Tue Dec 17, 2002 1:29 pm
Location: Gaithersburg, MD
Contact:

Post by daven »

LOAD DATA LOCAL INFILE "filepath/name" INTO TABLE tablename
tylerdurden
Forum Commoner
Posts: 66
Joined: Mon Jul 28, 2003 11:52 am
Location: Austria

Post by tylerdurden »

What kind of text file do you have? Tab delimited? Comma delimited? Or a dumpfile from another database. In any case have a look at http://www.phpmyadmin.net/ it will help you import files into MySQL (and with anything else concerning MySQL).

http://www.mysql.com/doc/en/Loading_tables.html is the official manual section.
Post Reply