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
select *from users;
Some Common Sql Commands
1. SELECT
2. INSERT
3. UPDATE
4. JOIN
5. DELETE
6. ALTER
7. DROP
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
Advertisements
