menu

SQL Syntax

Most Commonly used SQL Keywords are

SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, JOIN, USE, SHOW

Note :

  1. Sql is case insensitive means you can use both upper case & lower case
  2. 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

Advertisements