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
MySql
Moderator: General Moderators
-
tylerdurden
- Forum Commoner
- Posts: 66
- Joined: Mon Jul 28, 2003 11:52 am
- Location: Austria
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.
http://www.mysql.com/doc/en/Loading_tables.html is the official manual section.