> 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]

Reply via email to