Today's MySQL Suckage

[Matt Lawrence]

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 :-\
>
>   

mysql> /*
   /*> I am in your mysql
   /*> writing a comment
   /*> use mysql
[...]
Database changed

   /*> end of comment */
mysql>


Matt