Import CSV file directly into MySQL

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
lauthiamkok
Forum Contributor
Posts: 153
Joined: Wed Apr 01, 2009 2:23 pm
Location: Plymouth, United Kingdom

Import CSV file directly into MySQL

Post by lauthiamkok »

Hi,
How can I import the data from a spreadsheet into MySQL database? Are there many ways to do this with or without using php?
Many thanks,
Lau
User avatar
akuji36
Forum Contributor
Posts: 190
Joined: Tue Oct 14, 2008 9:53 am
Location: Hartford, Connecticut

Re: Import CSV file directly into MySQL

Post by akuji36 »

Hello

There are quite a few programs that can help you manage mysql databases:

I prefer phpmyadmin.

here are some alternatives:

http://www.heidisql.com/

or

http://www.mysqlfront.de/.

or

this example

http://www.sqldbu.com/eng/sections/tips ... mport.html


thanks

Rod Russell
webpagesofease.com :D
lauthiamkok
Forum Contributor
Posts: 153
Joined: Wed Apr 01, 2009 2:23 pm
Location: Plymouth, United Kingdom

Re: Import CSV file directly into MySQL

Post by lauthiamkok »

akuji36 wrote:Hello

There are quite a few programs that can help you manage mysql databases:

I prefer phpmyadmin.

here are some alternatives:

http://www.heidisql.com/

or

http://www.mysqlfront.de/.

or

this example

http://www.sqldbu.com/eng/sections/tips ... mport.html


thanks

Rod Russell
webpagesofease.com :D
got it thanks. managed to sort it out with phpmyadmin. thanks! :mrgreen:
Post Reply