Today's MySQL Suckage

Jonathan Stowe 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 mailing list