CODEWITHSUNDEEP
mysqlsqltoad
LWang
LWang

Reputation: 53

Can not execute update statement at toad for mysql but in other tools

I am using toad for mysql, but when I try to execute update the simple statement like UPDATE CART SET AID = 10005 WHERE ID = 10007; it show me the error:

Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

But the weird thing is it's working well in web application and other tools like HeidiSQL, Oracle sqldeveloper. Any one knows about this? is there any configuration of Toad for Mysql? thanks a lot.

Upvotes: 1

Views: 3589

Answers (1)

Tarik
Tarik

Reputation: 11209

Execute the following before your update statement:

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITED

Upvotes: 3

Related Questions