Using 5.0.7-beta the "drop trigger" functions in a very mysterious way:
mysql> use testdb; mysql> drop trigger foo; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql> drop trigger testdb.foo; ERROR 1146 (42S02): Table 'testdb.testdb' doesn't exist Seems like a serious bug to me. -- patrik_wallstrom->foodfight->[EMAIL PROTECTED]>+46-733173956 `-> http://www.gnuheter.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]