Welcome to Geeklog, Anonymous Monday, November 25 2024 @ 02:44 pm EST
Geeklog Forums
Very Cool CSV Importer
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
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
10
10
Quote
Anonymous
Anonymous
Yeah, phpmyadmin, how can you develop with out it
9
9
Quote
Status: offline
Blaine
Forum User
Moderator
Registered: 07/16/02
Posts: 1232
Location:Canada
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
Geeklog components by PortalParts -- www.portalparts.com
10
10
Quote
All times are EST. The time is now 02:44 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content