MS SQL Server vs MySQL Server

Asked By amscott 20 points N/A Posted on - 04/02/2012

Good evening everyone.

I would like to ask a little of your time to explain the difference between these two.

By just reading on the name, they just seem to be the same.

What is the difference between MySQL Server from MS SQL Server.

• Status: Open
• Question Views: 1416
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Wagura lorna

Go To Solution

Answered By Chung Opi 5 points N/A #100488

MS SQL Server vs MySQL Server

Yes by name they look like same but there is much difference in both of them.

As SQL that stands for structured Query Language, is basically a language, which is part of different computer programs and especially of the relational databases programs.

Alone SQL is nothing it requires many other programs like oracle etc. to run. On the other hand My SQL is one of the computer programs and can be downloaded for free as it is open source.

MySQL can be called as database management system.

Hopefully your query is resolved and it has become clear that things that look alike are not necessarily alike.

About Chung Opi

Questions
2

Answers
50

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 04/03/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Wagura lorna 0 points N/A #100489

MS SQL Server vs MySQL Server

Hi, both Mysql and Sql server will give you a good job on supporting all major protocol for accessing their databases.But there are some complaints against MYSQL which is it does not completely follow the ANSI SQL standard.You should upgrade your MYSQL to SQL if your data is constantly growing but remember to change the settings so that it will be able to communicate with the new data store that you established.In order to know the big difference between MYSQL and SQL.MYSQL is for selecting data on which you can saved delete and use it again,it is also a good choice in terms of tracking clients on which you need to do for your business online, for example maintaining your database or list of orders, clients name and details.

Technically SQL support triggers while MYSQL does not,SQL server support user define function MYSQL does not, SQL server have cursor support,MYSQL does not,SQL support stored procedures, MYSQL does not, SQL server have full join capabilities,MYSQL does not, SQL has full support for import/export capabilities, MYSQL has only limited support,SQL servers offers full Transaction support while MYSQL has limited transaction support.

About Wagura lorna

Questions
1

Answers
173

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 04/17/2012
• Question Category: MySQL Server