mysql支持调用begin end来执行代码块吗？

我在mysql官方提供的查询浏览器中编辑脚本如下：
begin
    delete oms.* from OMS_RES_ROLE oms where oms.role_id = '1';
    insert into OMS_RES_ROLE
      (ID, RESOURCE_ID, ROLE_ID, INIT_FLAG)
    values
      ('51', '27000', '1', '1');
    insert into OMS_RES_ROLE
      (ID, RESOURCE_ID, ROLE_ID, INIT_FLAG)
    values
      ('52', '32000', '1', '1');
    insert into OMS_RES_ROLE
      (ID, RESOURCE_ID, ROLE_ID, INIT_FLAG)
    values
      ('53', '26100', '1', '1');
end;
但是得到的结果却是数据库报错，
请问是不是mysql不支持像oracle一样直接调用 begin end 来执行代码块？
如果支持谁能告诉我怎么写吗？

评论

2 楼 tanghw234 2013-10-17  

BEGIN ... END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement can contain multiple statements, enclosed by the BEGIN and END keywords. statement_list represents a list of one or more statements, each terminated by a semicolon (;) statement delimiter. The statement_list itself is optional, so the empty compound statement (BEGIN END) is legal.
只支持在存储过程，函数，触发器等里面执行。

1 楼 tanghw234 2013-10-17  

不支持简单调用。