Welcome to Geeklog, Anonymous Wednesday, February 01 2023 @ 06:17 pm EST

Geeklog Forums

Very Cool CSV Importer

Status: offline


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.


Yeah, phpmyadmin, how can you develop with out it

Status: offline


Forum User
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

All times are EST. The time is now 06:17 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