Syntaxe Basic SQL

SELECT :

SELECT column1, column2, ... FROM table_name; 

WHERE :

SELECT column1, column2, ...FROM table_name WHERE condition;  

COUNT :

SELECT COUNT * FROM table_name ;

DISTINCT:

SELECT DISTINCT columnname FROM table_name;

LIMIT :

SELECT * FROM table_name LIMIT number; INSERT : INSERT INTO table_name (column1,column2,column3...) VALUES(value1,value2,value3...);  UPDATE : UPDATE table_name SET[[column1]=[VALUES]] WHERE [condition]; DELETE : DELETE FROM table_name WHERE [condition];