[resolved] Basic Database Help

thebiffenator · 05-07-2007, 12:39 PM

Where is a good place to start to build a database.

I know alot about computers mainly the graphics end, but I have never really dabbled with Excell or mysql, but I am sure I could learn it easily.

Anyway I have about 600 restraunts which I want to make a list of and include it to one of my websites. I have everthing in a word file "just the name, address, cusine and phone number is what I am entering." I guess the main thing is..What is the best way/program to import this data into a basic searchable database. Sorry if I am confussing. Also my other option is just giving the to someone and having them import it for me in to Excel or Mysql.

Thanks,
Brian

Peter · 05-07-2007, 03:23 PM

A good place to start would be http://www.devshed.com/c/b/MySQL also of course keep in mind the mysql manual located at http://dev.mysql.com/doc/ (there are also tutorial located at http://dev.mysql.com/doc/refman/4.1/en/tutorial.html). Be sure however to make sure you are reading the manual for the version of mysql you are using.

Regarding the best way to enter the content of the word doc into a database, it really depends on how the document is formed. I doubt it is csv so your only options might be is to use a scripting language or doing it manually.

thebiffenator · 05-07-2007, 04:58 PM

Quote:

Originally Posted by peter@flexiwebhost

A good place to start would be http://www.devshed.com/c/b/MySQL also of course keep in mind the mysql manual located at http://dev.mysql.com/doc/ (there are also tutorial located at http://dev.mysql.com/doc/refman/4.1/en/tutorial.html). Be sure however to make sure you are reading the manual for the version of mysql you are using.

Regarding the best way to enter the content of the word doc into a database, it really depends on how the document is formed. I doubt it is csv so your only options might be is to use a scripting language or doing it manually.

Thanks Peter REp Added

05-07-2007, 12:39 PM	#1 (permalink)
thebiffenator NamePros Regular Join Date: Oct 2006 Location: Philadelphia Posts: 824 25.00 NP$ (Donate)	Basic Database Help Where is a good place to start to build a database. I know alot about computers mainly the graphics end, but I have never really dabbled with Excell or mysql, but I am sure I could learn it easily. Anyway I have about 600 restraunts which I want to make a list of and include it to one of my websites. I have everthing in a word file "just the name, address, cusine and phone number is what I am entering." I guess the main thing is..What is the best way/program to import this data into a basic searchable database. Sorry if I am confussing. Also my other option is just giving the to someone and having them import it for me in to Excel or Mysql. Thanks, Brian __________________ mobiz.mobi USA's Mobile Locator Try it out! PHANS.MOBI Join Phans.mobi Phillies AreThe MLB Champs!!! Support the best team in Baseball.

05-07-2007, 03:23 PM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	A good place to start would be http://www.devshed.com/c/b/MySQL also of course keep in mind the mysql manual located at http://dev.mysql.com/doc/ (there are also tutorial located at http://dev.mysql.com/doc/refman/4.1/en/tutorial.html). Be sure however to make sure you are reading the manual for the version of mysql you are using. Regarding the best way to enter the content of the word doc into a database, it really depends on how the document is formed. I doubt it is csv so your only options might be is to use a scripting language or doing it manually.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)