0

Hi Friends

i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage.

Can any one help me to know about it.

2
Contributors
4
Replies
12
Views
5 Years
Discussion Span
Last Post by pritaeas
-1

Following are some specific technical differences in MySQL and SQL Server when it comes down to the ANSI SQL standard:

MySQL does not support Triggers, SQL Server does.
MySQL does not support User Defined Functions, SQL Server does.
MySQL does not have Cursor Support, 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.
MySQL has limited Transaction Support while SQL Server offers full Transaction Support.

0

MySQL does not support Triggers

Incorrect: http://dev.mysql.com/doc/refman/5.6/en/triggers.html

MySQL does not support User Defined Functions

Incorrect: http://dev.mysql.com/doc/refman/5.6/en/adding-functions.html

MySQL does not have Cursor Support

Incorrect: http://dev.mysql.com/doc/refman/5.6/en/cursors.html

MySQL does not support Stored Procedures

Incorrect: http://dev.mysql.com/doc/refman/5.6/en/stored-routines.html

MySQL has limited Transaction Support

Partially true, as it depends on your storage engine: http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-transactions.html

MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export

I hope you are not referring to MSSQL's wizard, because there are similar tools for MySQL.

Here you can find the differences in MySQL compared to ANSI SQL.

Edited by pritaeas

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.