Today's MySQL Suckage
matt.lawrence at virgin.net
Fri Jan 23 10:59:07 GMT 2009
Jonathan Stowe wrote:
> 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 :-\
/*> I am in your mysql
/*> writing a comment
/*> use mysql
/*> end of comment */
More information about the london.pm