menu

SQL Syntax

Most Commonly used SQL Keywords are

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

Note :

1 . Sql is case insenstive means you can use both upper case & lower case
2 . MY Sql : If you are using mysql, Table Name are case senstive 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



Leave a Reply