Hello,

I am super duper new to database. Can any good samaritan please explain to me what are MS SQL, MySQL, MS Access, MS SQL Server, MySQL Server?

And, most importantly, what are their relationship? Is MS SQL == MS SQL Server ???

Please help. I am confused at the moment. Waiting for someone to point out my confusion(s).

Thank you!

MySQL is what you will find on most linux hosting accounts and the only one I know anything about.

The ones with the MS in front of them are the windows versions I would guess.

That is about all the help I can offer.

Do you have a specific question?

We are cusrrently looking for someone that can create a SQL database for our site. Can anyone refer us?

Actually, yes I know MS shorts for MicroSoft. I just wanna know which one is a server, which one is language.

That means, are both MS SQL and MySQL languages to write the database? And is MS Access the database itself?

Something like that.

Thanks.

MySQL is available on most linux hosting and its free, it comes with no GUI interface to manage it you should use third party tools MS sql is paid one and your provider will charge for MS Sql database.

thanks

Originally Posted by Chia

Actually, yes I know MS shorts for MicroSoft. I just wanna know which one is a server, which one is language.

That means, are both MS SQL and MySQL languages to write the database? And is MS Access the database itself?

Uh ... MS SQL Server is (usually) a client/server database. You have all the data living on a server, and then send requests to it using the SQL language, or something like VB, C#, whatever. MySql is pretty similar, also (usually) server based, and you interact with it by sending SQL commands and doing something with the responses. MS Access is a different kind of database, more light-weight. It's a file instead of a server, although you still use SQL to interact with the data.

Sorry there isn't a more black and white answer, but it's somewhat complex stuff.

But like others have said, MySql usually comes with a web hosting account ( since most run linux ). On the other hand, Access comes with Office, so you might already have a license for it.

Thanks.

bottom line on all of this is that the language is SQL for any of the databases "structred query language" for a decent place to learn about sql with a free stand alone sql server is http://sqlcourse.com

good luck in your endeavors