MySql Syntax - SomOrg.in

1)DQl -Data Query Language

Select * from <tablename>;

Select * from <tablename> where <condition>

Select <columnname1>,<column name2> from <tablename> where <condition>

2)DDL-Data Definition Language
Create Command

CREATE TABLE <table_name> (
columnname1 <datatype(Size)>,
columnname2 <datatype(Size)>,
columnname3 <datatype(Size)>,
…
);

Alter Command

ALTER TABLE <table_name> ADD <column_name> <datatype(Size)>;

Truncate Command

TRUNCATE TABLE <table_name>;

Drop Command:

DROP TABLE <table_name>;

Rename Command:

RENAME TABLE `<oldTableName>` TO `<newTableName>`

Comment Command

SELECT <column1>, <column 2> /* Author: somorg.in */ FROM <table name>;

3)DML -Data Manipulation Language

Insert Command

INSERT INTO <table_name> (<columnname1>, <columnname2>,<columnname3>, …,<last column name>)
VALUES (<value1>, <value2>, <value3>, …,<value of lastcolumn>);

Update Commnad

UPDATE <tablename>
SET <column1>=<value1>, <column2>=<value2>,…,<astcolumn>=<value of last column>
WHERE <any_column>=<value>

Delete Command

delete from <table name> where WHERE <any_column>=<value>

DCL -Data Control Language

GRANT-gives user’s access privileges to database.

REVOKE-withdraw user’s access privileges given by using the GRANT command.

TCL – transaction Control Language

COMMIT-Commits a Transaction.

Rollback– Rollbacks a transaction in case of any error occurs.

SAVEPOINT-Sets a savepoint within a transaction.