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 belowSno.MYSQLSQL Server1Mysql is Available for  free. Mysql is an open source.Sql Server is not open source payment has to be made fro use of sql server.2Mysql offers only updateable viewSql Server offfers indexed view which are much more powerful performance wise.3Mysql doesnot 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 doesnot for offer any security certification. Sql server has C2 compliant certification.Database security verified by third party.7Earlier versions of Mysql doesnot support triggers. Only Mysql 5.0 supports triggers.Sql server provides trigger.8Cursor feature not available in MYsql.Cursor features available in Sql server.9Stored procedures and full join facility is not offered in Mysql.Stored procedures and full join facility offered in sql.10Import and export functions have very limited support in Mysql.Import and export functions have extensively support in Sql server.11Transaction support is very limited in Mysql.Transaction support is extensively and fully offered  in Sql Server.12Job 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.