Today's MySQL Suckage
jns at integration-house.com
Fri Jan 23 10:42:52 GMT 2009
2009/1/23 Denny <london.pm at metamathics.org>:
> On Fri, 2009-01-23 at 09:52 +0000, Andy Wardley wrote:
>> This table defines users of the
>> system who are Buffy fans.
>> $ mysql < my_db_schema.sql
>> It's interpreting the line "system who are Buffy fans." as a shell command,
>> even though it's inside a comment.
> I thought ;; was an SQL comment, with # also working for MySQL.
> Has /* ... */ always worked?
I thought it had always worked. But I tend to avoid MySQL if I can.
If it didn't recognise it as a comment in this case then there would
have been a different error. Which then raises the question as to why
it was trying to parse the contents of a comment at all :-\
http://rabidgravy.com/ - Music
http://gellyfish.co.uk/ - Everything else
More information about the london.pm