Answer Posted / krishna

In simple terms:
 
SQL is a common  database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) -- basically a standard interactive and programming language for querying and modifying data and managing databases.  Very standard for uses ranging from the simplest Microsoft Access applications, up to complex multi-server distributed Oracle applications.




MySQL is a multithreaded, multi-user SQL database management system (DBMS) providing multi-user access to a number of databases.  MySQL is commonly the back engine database for a great many applications, and often the database of choice for web-based applications.
 
Comparing the two is a little like comparing the English language to Tom Clancey's last book, one uses the other -- but from there the differences are many.

What is query optimizer in sql server?

957

---

What is primary key, unique key, and foreign key?

915

---

What is a user-defined function in the sql server and what is its advantage?

1044

---

What is bcp? When does it used?

920

---

where the connection string store in the database

2016

---

What happens if the update subquery returns no rows in ms sql server?

1073

---

what is the difference between a primary key and a unique key? : Sql server database administration

945

---

Tell me what are the advantages of using stored procedures?

946

---

‘Order by’ is not allowed in a view how can you sort information from a view?

1019

---

How to delete existing triggers using "drop trigger"?

990

---

What is the difference between lock, block and deadlock? : sql server database administration

990

---

Explain alternate key, candidate key and composite key in sql server?

860

---

How to optimize stored procedures in sql server?

1121

---

What is similarity and difference between truncate and delete in sql?

1028

---

Why should one not prefix user stored procedures with ‘sp_’?

985

---