I use SQL statements on an almost daily basis, yet I have trouble remembering the syntax of even the most basic commands. Thus I decided to post a cheat sheet here for quick and easy reference. I hope you may find it valuable.
|Selecting Records||SELECT * FROM Table WHERE Param1 < 10 ORDER BY Param2|
|Updating Records||UPDATE Table SET Param1 = ‘cat’, Param3 = ‘fish’ WHERE Param2 = ‘dog’|
|Adding Records||INSERT INTO Table (Param1, Param2) VALUES (‘xx’, ‘yy’)|
|Deleting Records||DELETE FROM Table WHERE Param1 = ‘value’|
|Group By||SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name = value GROUP BY column_name|
|List all tables & views in database||SELECT TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_TYPE, TABLE_NAME|