Well, I just read the mysql manual, and it appears I am wrong (although there is still a bug):
MySQL Server 3.23.3 and up also supports a variant of the `--' comment style. That is, the `--' start-comment sequence must be followed by a space (or by a control character such as a newline).[1] So, I guess the proper fix might be this: ----------- diff output -------- --- mysql.vim.old 2006-05-17 15:29:39.000000000 -0700 +++ mysql.vim 2006-05-17 15:29:51.000000000 -0700 @@ -67,7 +67,7 @@ " Comments (c-style, mysql-style and modified sql-style) syn region mysqlComment start="/\*" end="\*/" syn match mysqlComment "#.*" -syn match mysqlComment "-- .*" +syn match mysqlComment "--\_s.*" syn sync ccomment mysqlComment " Column types --------- end output ------------- -Bryan p.s. Another bug is that "/*! (mysql-specific commands) */" should be recognized as non-comments. But, I'll submit a real bug report when I make a patch for it (unless someone beats me to it ;) ). [1] MySQL 5.0 Reference Manual, Section 1.9.5.7. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-comments.html -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]