Posted on: 03/24/03 05:30pm
By: alinford
(I did not know what topic to put this under)
I found a script that will do CSV importing into MySQL via a graphical interface.
All you do is upload and run. Nothing to setup.
Very cool.
http://www.hotscripts.com/Detailed/18098.html[*1]
Very Cool CSV Importer
Posted on: 03/24/03 11:20pm
By: Anonymous (Anonymous)
Yeah, phpmyadmin, how can you develop with out it
Very Cool CSV Importer
Posted on: 03/25/03 07:21pm
By: Blaine
A very easy way to import in data to a mysql table is via the mysql load data statement.
Example: LOAD data INFILE 'c:/export.txt' INTO TABLE gl_mytable FIELDS TERMINATED BY ','
An export example to create a csv file:
SELECT * INTO OUTFILE 'c:export.txt' FIELDS TERMINATED BY ',' from gl_users