Imagine that you work mostly with C#. Imagine that on occasion you sprinkle SQL, Java and JavaScript into your daily routine, and that you also use the command line a lot.
Can you see the problem?
Didn't think so. I'll clue you in: the last one in that list has one distinct difference with the first four. Look around you. Have you found what we're looking for?
That is correct. The answer is: the semicolon. A lightweight, generally meaningless way to end a statement in most common languages. Arguably useless to users, arguably beneficial to parsers, and the cause of almost half an hour of continuous head-scratching by both programmer and DBA. How so?
C:\Temp>mysql -C -usomeuser -phispassword thedatabase;ERROR 1044 (42000): Access denied for user 'someuser'@'%' to database 'thedatabase;'
I'll let you draw your own conclusions.
Remember Me
a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u
© Copyright 2008 Tomer Gabel Based on theme design by Bryan Bell | | Powered by newtelligence dasBlog 2.0.7226.0 |  Page rendered at Tuesday, October 07, 2008 10:14:17 PM (Jerusalem Standard Time, UTC+02:00)