> > On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > > Hi there, > > > > > > Did I just see in the documentation that the "comment" clause > > > is being misused to supply a connection string for the federated > > > engine? > > > > > > If so, I sure hope it will be changed before the final 5.0 release. > > > > > > "comment" is next to useless like this. It's already being misused > > > by InnoDB to describe the FK constraints... > > Urm, where does it do that - my 4.1 server says > CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`) > REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`) > REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON > UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login' > > nothing in the comment field about key constraints - or is that new in 5?
show table status eg: InnoDB free: 10240 kB; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION; (`trans_id`) REFER `test/trans`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION Where's my original comment, if any? All in all, bad! With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
