http://www.netvouz.com/kapluni/tag/quick?feed=rss kapluni's bookmarks tagged "quick" on Netvouz http://www.fuzzyopinions.com/article/technology/the-developer-cheat-sheet-compilation kapluni Fri, 26 Oct 2007 17:02:31 GMT http://www.petefreitag.com/item/455.cfm Over 30 Cheatsheets for developers kapluni Fri, 26 Oct 2007 16:59:15 GMT http://www.ilovejackdaniels.com/cheat-sheets/ ILoveJackDaniels.com kapluni Fri, 26 Oct 2007 17:05:57 GMT http://www.deepx.com/resources/quickref/ Data Engineering and Electronic Publishing with XML Technologies kapluni Thu, 21 Sep 2006 17:19:57 GMT http://www.blinklist.com/tag/cheat%20sheet/ kapluni Fri, 26 Oct 2007 17:00:32 GMT http://ndpsoftware.com/HibernateMappingCheatSheet.html kapluni Mon, 18 Sep 2006 20:29:31 GMT http://www.pixelbeat.org/cmdline.html kapluni Tue, 10 Oct 2006 19:37:40 GMT http://www.mulberrytech.com/quickref/index.html Quick References kapluni Thu, 21 Sep 2006 16:31:24 GMT http://refcards.com/subject/all kapluni Fri, 26 Oct 2007 17:06:56 GMT http://www.free-cgi.com/freecgi/reference/sqlref.php SQL Quick Reference Guide Statements SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS FROM LIST OF TABLES OR VIEWS [ WHERE CONDITION(S) ] [ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ] [ GROUP BY GROUPING COLUMN(S) ] [ HAVING CONDITION(S) ] DELETE FROM TABLE NAME [ WHERE CONDITION(S) ] INSERT INTO TABLE NAME [ (COLUMN LIST) ] VALUES (VALUE LIST) UPDATE TABLE NAME SET COLUMN NAME = VALUE [ WHERE CONDITION ] Functions Function Purpose SUM Total of the values in a field. AVG Average of the values in a field. MIN Lowest value in a field. MAX Highest value in a field. COUNT Number of values in a field, not counting Null (blank) values. Predicates Predicate Description BETWEEN ... AND Compares a value to a range kapluni Thu, 04 Oct 2007 16:30:53 GMT