|
||
MySQL cheatsheets — Brilliant people forget stuff. — So clearly you need these.
|
|
Features:
|
|
|
Both Card and Chart:
|
“All arrive and distributed out. People oooo'd and aaaaaa'd. What would we change? Nothing - we just want more.” Mark Lentczner, Linden Lab “You have done the world a favor with the MySQL sheets as well as your previous work.” Phil Payne, Edgewood, NM |
|
“If you find out who or where to get a copy of that MySQL poster that Monty was carrying around, I'd be
very interested in getting a copy for my office here at Google.”
David Perron, Google's Manhattan Office, to another attendee of the MySQL Conference & Expo 2007
|
|
|
This is how you delete a database, what ISO calls a schema: Dropping a nonexistent database is ordinarily an error. MySQL forgives this when you use the optional phrase IF EXISTS but that's nonstandard. Format dates and times fast with clues from the example columns. |
Some MySQL functions: As the Legend (above) helps explain, POSITION()'s return value counts from one. It is zero for not found. |
Supporting details online:
See also the 16-page Browser Book
a complete set of cheatsheets
for client-side web design,
covering XHTML, CSS, fonts,
colors, special characters,
JavaScript and more.
Or, the 28-page Book Collection
combines the Browser Book
with the PHP Big Book
and the MySQL Card.
.