SQL Syntax
Most Commonly used SQL Keywords are
SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, JOIN, USE, SHOW
Note :
- Sql is case insensitive means you can use both upper case & lower case
- My Sql: If you are using MySql, Table Name are case sensitive means use the table names in MySql as they are
in MySql Database.
Semicolon :
Semicolon after syntax is optional after the each statement but always use semicolon after the statement.
Example
Some Common Sql Commands
1. SELECT
2. INSERT
3. UPDATE
4. JOIN
5. DELETE
6. ALTER
7. DROP
Advertisements
Add Comment
📖 Read More
- 1. SQL - Data Types
- 2. SQL - CREATE Database
- 3. SQL - Select Database
- 4. SQL - CREATE TABLE
- 5. SQL - INSERT
- 6. SQL - SELECT
- 7. SQL - WHERE Clause
- 8. SQL - AND & OR
- 9. SQL ORDER BY
- 10. SQL - UPDATE