Tech-Evangelist has put together an excellent cheatsheet for MySQL. There’s lots of other MySQL cheatsheets out there, but this one is unique in the fact that it gives examples of usage rather than just snippets of code.
This cheatsheet also includes a summary of commonly used MySQL data types, which will be really helpful to […]
Monthly Archives: September 2009
MySQL Cheatsheet By Example
Comments (2)
SQL Function Spotlight: TRIM
The SQL function TRIM has been around since Oracle 8i and maybe earlier. TRIM enables you to trim characters from a character string. The following examples demonstrate its usage and show you a few little known features of this simple function.
Remove leading and trailing blank spaces:
SQL> SELECT TRIM (’ mystring ‘) FROM dual;
TRIM(’MY
——–
mystring
Remove […]
Oracle Community Update
The social network for Oracle people OracleCommunity.net was launched on January 31, 2008. Since then, it has had a tremendous growth. We went from 1 to 2,445+ members in 8 months. Existing features have been enhanced and new features have been added. Features like chat, events and the iPhone version did not even exist when […]