MySQL can blow me

[k8mnstr.livejournal.com]

I have gotten like 4 really fucked up MySQL cases today and I'm completely burnt out. If I have to stare at the MySQL command line one more time I'm going to fucking explode.

mysql --user=kaytie --password=daddysgirl kaytie

mysql> show variables like "patience";
Empty set (0.00 sec)

mysql> help

There is no help for you, may we try the following options?
drink		(\d)	Sets drink query delimiter to TRUE
ego		(\e)	Inflates ego (currently disabled)
home		(\h)	Attempts to go home, unable to leave at this time
quit		(\q)	If only you could...
rehash		(\#)	Reinvent the wheel?

For additional help, type 'sepakku'

X-Posted to my journal

Comments

[azzy23.livejournal.com]

Y'know... I frickin' hate SQL in general. I hate that I have to support it, and that I've never gotten trained on it. My form of protest?

truncate table events

Eventually I'll get in trouble for this. But I haven't yet.

[jecook]

I am moderately thankful that the SQL databases that have been under my care have been remarkably well behaved.

Even the one that had a bunch of mission critical crap that I used for my job that the boss forced me to kill off because I was hosting it at home instead of on a crappy work machine, and because it ran on a unix platform instead of M$.

[japester.livejournal.com]

erm ... you need an extra '%' or two in there ...

mysql> show variables like "%patience%";


however, I share your pain. mysql is breaindead in so many ways it's not funny.

[k8mnstr.livejournal.com]

Actually if you run...

mysql> show variables like "tmpdir";

it will output something like

adding the "%" sign will should be used if there's an assigned variable or table name, or if it's being run via a shell script... at least that's my experience with it.

^.^

[squigit.livejournal.com]

I can't immagine what'd be like to support users who knew what a database was

[blasphemy.livejournal.com]

Best icon ever.

[jokergirl.livejournal.com]

select * from users where clue>0 ?