How is the Microsoft SQL better than MySQL? Which is better for security? E-Commerce? Most importantly, Which uses a cheaper server to run on the web?
2006-08-30 04:52:22 · 5 answers · asked by Nicholas M 1 in Computers & Internet ➔ Programming & Design
Microsoft SQL has some functions not available in MySql, but the difference in capabilities is not really significant. I would say they are equally suitable for e-commerce. Security is a harder call, but my personal prejudice is for the open source software (MySql), as there is a developer community watching over it.
The biggest disadvantage of Microsoft SQL is that it has to be run on a Windows server. MySql can be run on virtually any platform. It is often used on Linux servers running Apache. Your software costs with MySql can be significantly less, though you may spend a bit more time setting it up.
2006-08-30 08:40:09 · answer #1 · answered by injanier 7 · 0⤊ 0⤋
The big difference is that Microsoft SQL is a proprietary of Microsoft, whereas MySQL is free (almost) and an Open Source database. You can download it from them, even the source!
Recently MySQL had just won from competition! (see from mysql website).
When you are searching for webhosting, you will see almost that their website are hosting for MySQL!
2006-09-01 15:24:29 · answer #2 · answered by VBACCESSpert 5 · 0⤊ 0⤋
sq. stands for shape question language.It describe those languages that would fetch information from database making use of question string Mysql is a unfastened database.you could save ,retrive and technique information in mysql database.
2016-09-30 04:16:40 · answer #3 · answered by ? 4 · 0⤊ 0⤋
Most of the differences are efforts of each developer to remain unique. So minor changes are made to ensure continued use.
2006-08-30 05:08:19 · answer #4 · answered by Jack G 3 · 0⤊ 0⤋
Here's a very in-depth article comparing them: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm
2006-08-30 05:01:37 · answer #5 · answered by Anonymous · 0⤊ 0⤋