Convert csv to mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Convert csv to mysql

Post by Luke »

What do y'all use to convert csv (comma delimited) files to mysql tables? Isn't phpmyadmin supposed to be able to do this? Mine doesn't give me that option...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

There's fgetcsv(), there's mysqlimport, LOAD DATA INFILE.. a few other options around here and there...

viewtopic.php?t=22168 for a previous thread...
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

LOAD DATA INFILE worked like a charm... didn't know about that one... thanks man!
Post Reply