View Full Version : Will -I- need MySQL...?
10-5-02, 07:43 PM
I only have a pretty basic personal site. I've got MySQL supposedly now thanks to Powweb, but I was wondering if buying a dummy book to learn it would have any advantage to me at all. I'm confused about databases and only know that they're for storing information. I don't understand exactly what information you would want to store on them for a website though...so my only guess would be that they're for businesses(?). I only know the very very basics about PHP and don't see why I'd need MySQL to go along with it.
Even though I'm completely confused I guess the best way to put it is: Should I buy a book to learn MySQL? And could learning it help me do anything at all to either a personal site or an HTML help site? I'll probably be wanting to create a forum soon, but would MySQL add more options for creating one in some way?
Any information would be greatly appreciated :).
10-5-02, 08:27 PM
There are so many good boooks in the market but I would suggest that go to their site and have a look on their documentation.
10-7-02, 01:38 AM
Hello HLynn411 and Newcomer,
Like HL I am wondering about taking the jump to MySQL. I have done dBase programming in the past.....well past! HL, Thanks for posting this. I just saw the new price for MySQL and am now considering 'playing' with it.
Newcomer, I agree that pointing in the right direction is normally very helpful, but in this case I am not sure. I went to the mysql.com site and I still have more questions than answers. Mostly related to the jargon I believe. The one time I REALLY want to look at sales crap and I cannot find it!
I guess I should not complain with the new $10 fee here, but from what I can see, I will need a whole new library with a 3 inch dictionary just to get going.
Is there anywhere one can go to really get into the basics? Or do I really need to get a Dummy book on MySQL?
HL you seem to be quite ahead of me on this because you mentioned you downloaded MySQL and have some of it going. Your a better man than I am Gungadin!
Any thoughts here would be considered VERY helpful.
Thanks in advance!
10-7-02, 06:49 AM
Oh, trust me, I can't be much further than you because even though I've supposedly gotten some things with MySQL started I have no clue how/why to use them in the least. I just saw a referral credit on my billing page so I figured why not try buying MySQL with some of that money.
I'm definitely considering getting some sort of tutorial book, too. I've been to mysql.com numerous times and am still finding myself lost and confused (one of those dummy books are sounding real good about now...).
Any/all recommendations on basic basic MySQL books I would happily go buy. After all, I do have some random thing I paid money for just sitting on my site now, lol.
I'm glad I'm not the only one who's still on the confused side :D haha. I figured the answer to all this was as easy as learning HTML... imagine my surprise now just 3 days later, after paying for it and supposedly configuring it with nothing to do after that, heh.
the main benafit to having a database is that you seperate the page coding from your content. the content goes in the database, (say a collection of the short stories you have written,) but instead of having to code lets say 70+ pages you have the code for the page in a script that asks for the story from your data base. you can see an example here, elderstories.org (http://elderstories.org) more so than a book on mysql, though that's good too, get one on cascading style sheets and whatever scripting language would be used for accessing the data. PHP is probably the most popular script language now, but perl is good too. they each have their strengths and limits.
If you are planning on getting a forum, a forum uses a database. The database is needed to store the messages, users. You don't need MySql, but it does run much faster than a flat file(text) database (these databases can be very simple files such as .txt extensions). MySql can be run through programming scripts such as perl/cgi or php. MySql. unlike flat file databases can handle more operations at a time.
Have you tried running MySQL locally on your own computer? If you feel you need to learn about databases and SQL, it might be helpful to download and try it out on your own computer first.
By running locally, you can use a program such as WinMySQLAdmin to set up a database, put tables into it, and get an idea how tables work together.
You can also write simple SQL statements using the mysql.exe command-line (text-based in a DOS window, for example) program that comes with MySQL itself, to write SQL statements (INSERTs, DELETEs, UPDATEs, etc.) and get the hang of SQL.
The whole point of doing this locally, is that you can learn about MySQL, databases in general, and SQL without having to learn how it fits into the whole PHP or Perl world.... no programming necessary to start, just one-line SQL commands. Once you get the hang of it, you can set up MySQL on Powweb, and go to town :-)
Just a thought.... good luck!
10-9-02, 12:52 AM
Thanks for all the input you guys :). It's really helped a lot.
Yes, I've managed to access it using DOS from my computer while going through a very very basic tutorial I found online. I also created tables, added information to them, changed the information in certain sections, and deleted it. I was very proud of myself, lol.
I just installed PhpMyAdmin and uploaded that to my site and I think that should be working, too. I haven't played around with that at all yet though.
Maybe I'll be able to create a forum using this after all in the future! Lol.
Sounds like you're well on your way. On my local PC is the only place I've installed it myself, so you're now treading ground new to me... I'll probably be asking YOU for advice before long!
10-9-02, 01:21 AM
Hahaha, I don't know about going -that- far... but now I'm excited!
It's all about the little things in life I guess, heh.
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.