Search
 
SCRIPT & CODE EXAMPLE
 

SQL

1422: Explicit or implicit commit is not allowed in stored function or trigger

create procedure test( a int )
MODIFIES SQL DATA
BEGIN
  START TRANSACTION ;
  update t set col='some value' where id=a ;
  COMMIT ;
END //
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql select row with max value group by 
Sql :: restore backup "text" postgresql command line 
Sql :: mysql decimal 
Sql :: could not assemble any primary key columns for mapped table sqlalchemy 
Sql :: mysql switch case 
Sql :: oracle undo tablespace list by user 
Sql :: mysql show foreign keys column 
Sql :: mysql group by 
Sql :: alter table query in mysql 
Sql :: get current date sql 
Sql :: sql query to return field name of a table 
Sql :: sql check if table exists 
Sql :: Import zipped mysql dumps 
Sql :: sql as 
Sql :: mysql date_format 
Sql :: get month sql 
Sql :: having clause in sql 
Sql :: install mysql 
Sql :: mysql sublime build system 
Sql :: Rows, INSERT INTO, Returning 
Sql :: azure sql get all users 
Sql :: case vhdl 
Sql :: mssql coalesce 
Sql :: tsql from yyyymm to date 
Sql :: xml to column sql 
Sql :: mysql remove tabs from string 
Sql :: update query in sql 
Sql :: cast as decimal postgresql 
Sql :: between keyword sql 
Sql :: IntegrityError at duplicate key value violates unique constraint DETAIL: Key id already exists. 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =