What's the difference between mysql, phpmyadmin, SQL

[rpv_sen]

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.

[pritaeas]

SQL is a language to query a database for information. MySQL is a specific brand of server and PHPMyAdmin is a server tool to access the databases on MySQL servers.

[rpv_sen]

Hi Pritaeas

Thanks for your reply.

[rpv_sen]

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.

[pritaeas]

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.