hi, I am new with databases. Can anyone tell me the difference between MySQL and SQL?
SQL is a standard language for communicating with Databases. MySQL is an opensource database that uses (parts of) that standard.
Are you asking about the difference between MySQL and MS SQL Server?
thanks for the reply. Yeah...I would like to know the difference and when I should use which. I am developing a small stand-alone program and I am trying to figure out which one to use.
Depends on what you need from your database, and what kind of footprint you want.
MySQL is small, simple and free. MS-SQL has much better SQL support, but it is very expensive and requires a large computer to make it run smoothly.
thanks vincent. I need a simple database which can help me organize my data really efficiently. I am creating a "learning" database which is related to Artificial Intelligence.
If you are just after organizing your data (like in an adressbook etc), then MySQL will do. If you plan to use the database to do real AI things, you'll need MS-SQL / oracle / informix, because MySQL simply does not understand complex SQL.
is MySQL any different from ms-access 2000? which one is better and more stable?
Access is a stand alone program, MySQL is a server component. Access has its benefits, mainly it is standalone and very graphical. MySQL doesn't do that stuff without someone coding it for you.
