04-03-2007, 07: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.
04-03-2007, 07:39 PM
The import feature in phpMyAdmin is a good place to start.
04-03-2007, 07:42 PM
And you could check this similar thread from the mysql forum.
04-04-2007, 11: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..
04-04-2007, 11:38 AM
Erm, he just uploads the csv file. There is no copy & pasting.