02-09-2017, 10:49 AM
SQL, 'Structured Query Language', is a programming language designed to manage data stored in relational databases. SQL operates through simple and declarative statements. This keeps data accurate and secure, and helps maintain the integrity of databases, regardless of size.
SQL is followed by a unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQL listing all the basic SQL syntax.
All SQL statements begin with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW, and all statements end with a semicolon (.
The most important point to note here is that SQL is not case-sensitive, which means SELECT and select have the same meaning in SQL statements. Whereas, MySQL makes a difference in table names. So, if you are working with MySQL, then you need to give table names as they exist in the database.
SQL is followed by a unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQL listing all the basic SQL syntax.
All SQL statements begin with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW, and all statements end with a semicolon (.
The most important point to note here is that SQL is not case-sensitive, which means SELECT and select have the same meaning in SQL statements. Whereas, MySQL makes a difference in table names. So, if you are working with MySQL, then you need to give table names as they exist in the database.