| This is considered as an icon or symbol for SQL |
Although, there are many different versions of SQL available but they all have the same basic commands like SELECT, UPDATE, ALTER, DELETE, DROP, WHERE, etc.
It is based upon relational algebra and relational calculus and SQL consists of data manipulation language, data control language and data definition language. It is generally considered as a fourth-generation programming language (4GL). However, it also includes procedural elements.
In 1970 an English computer scientist Edgar F. Codd, invented the relational model for database management, while working for IBM. It consists of 12 rules commonly known as Codd's 12 rules. Although, SQL does not strictly follow all those rules, it is most popularly used database language.
What is the difference between SQL and MySQL?
This is a very common confusion among some people that they think both MySQL and SQL are same but they are different in fact.
As we have already discussed above, SQL is a standard language for working with databases.
Whereas, MySQL can be defined as a database management system, similar to Oracle SQL,
Informix, Postgres, Microsoft SQL, Mongo DB etc. MySQL is a RDBMS or Relational Database Management System.
No comments :
Post a Comment