What is difference between SQL and MySQL?
SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database.
MySQL is an open source Relational Database Management System (RDBMS) based on Structured Query Language (SQL). It runs on platforms like Linux, UNIX and Windows.
MS SQL Server | MySQL |
Developed by Microsoft. | Developed by Oracle. |
It supports programming languages like C++, JAVA, Ruby, Visual Basic, Delphi, R etc. | MySQL offers extended running support for languages like Perl, Tcl, Haskey etc. |
Expects a large amount of operational storage space. | Expects less amount of operational storage space. |
It enables for stopping query execution. | It doesn't allow query cancellation mid-way in the process. |
Doesn't block the database while backing up the data. | Blocks the database while backing up the data. |
It is not free. | It is open source. It is freely available. |
It is a highly secured and doesn't allow any kind of database file manipulation while running. | It allows database file manipulation while running. |
It is available in multiple editions, such as Enterprise, Standard, Web, Workgroup, or Express. | It is available in MySQL Standard Edition, MySQL Enterprise Edition, and MySQL Cluster Grade Edition. |
0 Answers
0Be the first to answer this interview question.
Your Answer
Sign in to post your answer and help the community.