SQL Notes

• SELECT

SELECT *|column,column... FROM table

WHERE condition

ORDER BY ASC|DESC

• Logical Operators

  • NOT

  • AND

  • OR

• DELETE 

DELETE * FROM table  --Delete all rows from a table

DELETE FROM table 

DELETE FROM table  --Delete rows from a table satisfying condition

WHERE condition;

• SET

UPDATE table 

SET 

    column = value

WHERE condition;

• REPLACE (str, old_substr, new_substr)

UPDATE table 

SET 

    column = REPLACE(column, old_substr, new_substr)

WHERE condition;