MYSQL Vs SQL



MySQL Vs SQL


MySQL and SQL are the top leading databases that supports the front end applications that relates various domains.Lets check out the distinct features between the MySQL and SQL Server.


MySQLSQL Server
MySQL is available for free since it is an open source. SQL Server is not an open source and have to make a payment to use it.
MySQL offers only updateable views.SQL Server offers indexed views which are much more powerful,performance wise.
MySQL does not support XML.SQL Server supports XML.
MySQL provides only table level security.SQL Server provides column level security.
MySQL does not offer any certification for security.SQL Server has C2 complaint certification.Database security is verified by third party.
Earlier versions of MySQL does not supports triggers.Only MySQL version 5.0 supports trigggers.SQL Server provides triggers.
User Defined Functions are not supported in MySQL.User Defined Functions are supported in SQL.
Cursor feature is not available in MySQL.Cursor feature is available in SQL Server.
MySQL was developed by Oracle.SQL Server was developed by Microsoft.
MySQL supports many platforms as compared to SQL Server.SQL Server supports only Linux and Windows platforms.
It is found that MySQL Syntax is little bit complex.SQL Server syntax is simpler and easy to use.
MySQL was mainly in programmed in C and C++ programming language.SQL Server was mainly programmed in C++ but some parts in C as well.


MySQL TRIGGERS

MySQL - Triggers

posted on 2019-11-29 21:44:07 - mysql Tutorials


Grant_ Revoke Privilege

MySQL - Grant_ Revoke Privilege

posted on 2019-11-26 23:15:04 - mysql Tutorials


MySQL Vs SQL

MySQL Vs SQL

posted on 2019-11-25 05:02:26 - mysql Tutorials


What Is Oracle

What Is Oracle

posted on 2019-11-29 01:11:21 - ORACLE Tutorials


TRIGGER

ORACLE - Trigger

posted on 2019-11-28 22:14:22 - ORACLE Tutorials


CURSOR

ORACLE - Cursor

posted on 2019-11-28 22:13:54 - ORACLE Tutorials