Status: offline

alinford

Forum User
Regular Poster
Registered: 01/06/03
Posts: 96
(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

Anonymous

Anonymous
Yeah, phpmyadmin, how can you develop with out it

Status: offline

Blaine

Forum User
Moderator
Registered: 07/16/02
Posts: 1232
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
Geeklog components by PortalParts -- www.portalparts.com