...

View Full Version : MySQL Database Help



AJW06
04-03-2007, 06:21 PM
Hello Fellow Coders.

I have a large number of names to enter, 700 infact, all of which are in a spreadsheet. is there a quick method of entering all this information into a MySQL Database.

Inigoesdr
04-03-2007, 06:39 PM
The import feature in phpMyAdmin is a good place to start.

david_kw
04-03-2007, 06:42 PM
And you could check this similar thread from the mysql forum.

http://www.codingforums.com/showthread.php?t=101172

david_kw

mabuc
04-04-2007, 10:34 AM
Ill give you the steps on how to import your record:

1. goto to your PhpMyAdmin site then create a database..
2. Click the SQL menu of your database and copy paste your code in the textarea of the SQL menu.
3. Click go button
4. And bingo you have now the 700 hundred records in your database, its easy and its fast...

but be sure you have entered it already in localhost server... before you can copy and paste your SQL..or you have to create first in notepad but you can consume more time in that...

Thanks and Happy Coding Guyz..

Nightfire
04-04-2007, 10:38 AM
Erm, he just uploads the csv file. There is no copy & pasting.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum