> I execute follow procedure: > > ----------------------------------------------------------- > create procedure test_transation_rollback() > begin > start transaction; > create table t_34d (c1 int,c2 char(30)); > rollback; > end > ------------------------------------------------------------ > > After execute this procedure,i find the table "t_34d" in my schema.Why? >
Metadata transactions are not supported in MySQL. 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]