differences between sql and mysql?

Answer 1

SQL stands for Structured Query Language.... it is the language used to create, modify and report relational databases. It is not specific to an implementation of the language.... MySQL is a relational database manager that uses SQL to manage and use the databases. Just as Microsoft SQL Server does the same on a Windows NT Server. However, MySQL lacks the GUI tools that shield you from the complexities of having to type out all the SQL commands.

Answer 2

Hi,

SQL is stands for Structured Query Language. It is the language used to extract, manipulate data in a relational database.

Many people abbreviate Microsoft's SQL Server to just SQL. This is a very high quality, professional database software. The primary problem is that the license cost is $2500+ per server which makes it too expensive for some smaller companies.

MySQL is also a relational database software. It is free to install and works on both Windows and Unix environemtn. The mySQL product is a fully functional database, but does not have the nice built in UI of the Microsoft product. (IE Query Analyzer for the SQL gurus).

I have professional experience with both products, and they both have their place. If you are looking to learning database stuff, concentrate first on learning the language and then choose the db that has the most traction in your industry.

Hope this helps,

Answer 3

Mysql is an open source sql relational database, mssql is microsofts.

Differences are mssql is tightly integrated with windows, you can use windows logins for authenticating, it has alot more features with triggers, stored procedures and views.

Mysql is a good database, but doesn't have as many features as mssql. But for what I do Mysql works great.

I have both and prefer to use Mysql over mssql.

Mssql is also alot more money

Oh and there are many, many gui tools for Mysql that work well I use EMS manager and it creates the statements for me.

Answer 4

When considering a utility for data management the two most popular choices are MySQL and SQL Server. Both are efficient at keeping your data organized and readily available through a user interface, but they differ drastically in many areas

for diff visit this link

http://www.tometasoftware.com/mysql_vs_sqlserver.asp

Answer 5

SQL is from Oracle and Mysql is Open source. MySql is more simple than sql.