Difference between MySQL and MSSQL ?

HI,

I want to ask all about database structure. So Please tell me about all database structure And also mysql. And also tell me the diffence between mysql and mssql.

Thanks & Regards
passion

We have a good white paper on this on our site. This system won't let me post a URL but my user name is the site

Hello passion12345, here is what I researched about your question. Hope it can help.


Differences Between MySql and MS SQL

One thing you have to watch out for is the fairly severe differences in the way MSSQL and MySQL implement the SQL syntax.

Here's a nice Comparison of Different SQL Implementations.

For example, take a look at the top-n section. In MySQL:

SELECT age
FROM person
ORDER BY age ASC
LIMIT 1 OFFSET 2

in MSSQL (T-SQL):

SELECT TOP 3 WITH TIES *
FROM person
ORDER BY age ASC



Microsoft SQL Server

Did you mean: Microsoft SQL Server, Microsoft SQL Server (technology), mSQL (technology)



MSSQL : Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL.

MySQL is a relational database management system (RDBMS)[1] which has more than 11 million installations.[2] The program runs as a server providing multi-user access to a number of databases.

sources:
stackoverflow
answer.com
answer.com

You have explained in a very attractive way.
I really impressed.

Thanks

MySQL is more likely to have database corruption issues, and it doesn't fix them automatically when they happen. I've worked with MSSQL since version 6.5 and don't remember a database corruption issue taking the database offline. The few times I've worked with MySQL in a production environment, a database corruption issue took the entire database offline until we ran the magic "please fix my corrupted index" thing from the commandline.

MSSQL's transaction and journaling system, in my experience, handles just about anything - including a power cycle or hardware failure - without database corruption, and if something gets messed up it fixes it automatically.

I have never faced such a situation with MySQL.

Usually it's only a single table that gets corrupted.
But that doesn't take down the whole database offline; the other tables remain functional.

Having a system of auto-repair in MySQL too would be great to have.

Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are supported by MS-SQL

Non Technical - MS SQL is an expensive (*relatively*) proprietary RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of Sweden with free as well as paid enterprise versions available.

• MySQL does not support Triggers, SQL Server does.
• MySQL does not support User Defined Functions, SQL Server does.
• MySQL does not support Stored Procedures, SQL Server does.
• MySQL does not have FULL JOIN capabilities, SQL Server does.
• MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export.

@khizarhatyat:

MySQL DOES support triggers, stored procedures and functions.
(starting MySQL 5.0, I guess)

One thing you have to watch out for is the fairly severe differences in the way MSSQL and MySQL implement the SQL syntax; and other You will see when You work on.