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
 Quote

Anonymous

Anonymous
Yeah, phpmyadmin, how can you develop with out it
 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
 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