MySQL boredom

By Geoff Richards, 2002 Sep 15 at 23:14

Constructing silly queries.

Didn't have time to post this when I discovered it, but there was a point where writing a MySQL course recently that things got a bit silly. That's the only explanation for how I found that this is valid SQL as far as MySQL is concerned:

create database `grant`;
use grant;
create table `grant` (foo int);

grant grant option
   on grant.grant
   to 'grant'@grant
   identified by 'grant'
   with grant option;

The backticks are required to trick it into thinking that grant is a reasonable name for a database or table.

< MakeMaker makes me mad | Bloody Slackware, Bloody Mary >

Miniblog

(nuggets of inanity)

Tuesday Apr 24th 2007, 16:54 »
Just took the annual web design survey that AListApart do. I don't realy consider myself to be a web designer, but I have been doing a lot of HTML and CSS lately.
Monday Apr 23rd 2007, 18:23 »
Strange, there appears to be a bare-knuckle boxing match going on in the field outside my flat. Wish they wouldn't make so much noise about it.
Thursday Mar 1st 2007, 18:47 »
“In its written form, Hebrew has no vowels, making it the ideal language for texting.”
—Said in jest on some Radio 4 programme just now.

Archive: 2007 · 2006 · 2005 · 2004
Feed