Few simple questions regarding MySQL, please help!

[JoJoH]

Hi,

I am currently thinking about switching from MS Access to MySQL, yet I am completely new to it... and I have a few questions in mind... any help will be greatly appreciated.

1)Is switching from MS Access to MySQL a complicated process? What does it take?

2)Could you use visual basics or vbscript with MySQL? Cause I have browsed through Amazon.com and most of the books are about using PHP with MySQL and I don't see any books regarding using vb with MySQL.

3)I've read that MySQL is free for non-commercial uses but for commercial purposes, you have to pay... what does he mean by "commercial purposes"? Does it mean if I have a online store that sell things and I use MySQL to store my product info, than that is commercial purposes?

4)Could you please recommend some good books or tutorial on MySQL?

Please advice.
Thanks in advance.

 

[JustKIDn]

I'll try.

1-2) Complication comes in how you approach it. What do you plan to do with it? What do you plan to use as your front-end (fe)? You can still use Access for the fe and MySQL as the back-end (be).
Yes you could also use VB for the fe. If you don't like PHP, you can use Perl.
Again what do you want to do? If you want a web interface with a browser, then Perl, PHP, Python, (or one of those 'P' words) will work. There are others but those are common. How about Ruby?
Or do you want a stand alone GUI application? Then Access, VB, C++, Delphi, or many other languages will work. Shall we move on?

3) My understanding of "commercial purposes" is MySQL is free for anything you want to do with it unless you create an application that includes MySQL and is sold.

4) MySQL.com has all the documentation and examples. I haven't looked into books yet. There are also websites which may be better than books.

HTH
tgus

____________________________
Families can be together forever...

 

[gogirl]

I recommend PHP and MySQL Web Development by Welling and Thomson. It gives you the basics of mysql and php and walks you through creating some web apps. Also, the O'Reilly books are good.

Good Luck,

gogirl