SQL SELECT, INSERT, UPDATE, DELETE

SQL Select Statement, Insert Statement, Update Statement and Delete Statement

SQL SELECT STATEMENT


SELECT * FROM table-name

SELECT column1, column2, column3 FROM table-name

SELECT * FROM table-name WHERE `column-name`='value'

SELECT * FROM table-name WHERE `column1`='value1' AND `column2`='value2'

SELECT * FROM table-name WHERE `column1`='value1' OR `column2`='value2'

SELECT * FROM table-name 
WHERE (`column1`='value1' AND `column2`='value2') 
OR (`column3`='value3' AND `column4`='value4')

SELECT * FROM table-name 
WHERE (`column1`='value1' OR `column2`='value2') 
AND (`column3`='value3' OR `column4`='value4')

SQL INSERT STATEMENT


INSERT INTO TABLE-NAME (`column1`,`column2`,`column3`) 
VALUES('value1','value2','value3');

INSERT INTO TABLE-NAME  
VALUES('value1','value2','value3');

SQL UPDATE STATEMENT


UPDATE TABLE-NAME SET `column1`='value1', `column2`='value2' WHERE `column3`='value3'

UPDATE TABLE-NAME SET `column1`='value1', `column2`='value2' WHERE `column3`='value3' AND `column4`='value4'

UPDATE TABLE-NAME SET `column1`='value1', `column2`='value2' WHERE `column3`='value3' OR `column4`='value4'

UPDATE TABLE-NAME SET `column1`=`column2` WHERE `column3`='value3'

UPDATE TABLE-NAME SET `column1`=`column2`

SQL DELETE STATEMENT


DELETE FROM TABLE-NAME WHERE `column1`='value1'

DELETE FROM TABLE-NAME WHERE `column1`='value1' AND `column2`='value2'

DELETE FROM TABLE-NAME WHERE `column1`='value1' OR `column2`='value2'

Share