PDA

View Full Version : Needing help creating MYSQL database


turhapuro
11-24-2007, 11:27 PM
Greetings

I have this banana project and i need to fetch stuff from MYSQL database to make listings. So now i'm wondering what is the best way to create table that has 10.000 entries.

1. What should i do to easy up my work? Do i just manually insert them in myphpadmin?
2. I'm still newbie and don't understand much about MYSQL database, so if i need to make list or fetch information that is the following.

Banana Name
Banana Import Country
Banana costs per KG

Now this list will be huge, so all help appriaceted!

Thanks in advance!

Turhapuro

Vege
11-25-2007, 02:28 PM
You know how to create a basic table?
As your specification about bananas seems to be simple one table.

Still you need to think about table indexes that can reduce the selecting time from table dramatically if table is large and usually data is selected from table.
http://www.databasejournal.com/features/mysql/article.php/1382791

themanwhowas
11-25-2007, 05:12 PM
if all 10,000 entries have different values then there is no easy way. if they have the same, or if some of the fields in each entry will be the same then you could use php or something to loop the entry.