Why I write a mysql function, an error, please correct what to write-CodePudding

Home > database > Why I write a mysql function, an error, please correct what to write

Why I write a mysql function, an error, please correct what to write

Time：09-22

The create function test () returns an int
The begin

The create table a (int a);
Int the create table b (b);
return 1;
end

CodePudding user response:

ERROR 1422 (HY000) : Explicit or implicit commit is not allowed in stored function or trigger.

Cannot do DDL in function, also is cannot build table, give up the idea

Page link：https//www.codepudding.com/database/20691.html

Prev:What a great god to help solve the problem of connection pool c3p0 under

Next:Python - 1064 times wrong programingError MYSQL insert data

Tags：

MySQL

Links：
CodePudding