PHPGurukul

Difference between SQL and MYSQL

Mysql and sql are the two leading database that support front end application. The Diffrence between sql and mysql are given below Sno.

#MySQLSQL Server
1MySQL is Available for  free.Sql Server is not open source payment has to be made fro use of sq server.
2MySQL offers only update-able view.Sql Server offfers indexed view which are much more powerful performance wise.
3MySQL doesn't support XML.SQL server supports XML.
4User defined function are not supported in MySQL.User defined functions are  supported in SQL server.
5MySQL provide only table level security.SQL server provide column level security.
6MySQL doesn't for offer any security certification.Sql server has C2 compliant certification.Database security verified by third party.
7Earlier versions of MySQL doesn't support triggers. Only MySQL 5.0 supports triggers.SQL server provides trigger.
8Cursor feature not available in MySQL.Cursor features available in SQL server.
9Import and export functions have very limited support in MySQL.Import and export functions have extensively support in SQL server.
10Transaction support is very limited in MySQL.Transaction support is extensively and fully offered  in SQL Server.
11Job scheduling and profiling are nor available in MySQL.Job scheduling and profiling are available SQL server.

Anuj Kumar

This is Anuj Kumar. I’m a professional web developer with 4+ year experience. I write blogs in my free time. I love to learn new technologies and share with others.
I founded PHPGurukul in September 2015. The main aim of this website to provide PHP, Jquery, MySQL, PHP Oops and other web development tutorials.
.

Recommended Tutorials for you


4 comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Web Hosting with a FREE domain. On sale ₹99.00/mo

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.