Disable Update When Change Rows

[peterlaursen]

No.

[peterlaursen]

Let me add that what you should conisder to do here, is to use transactions. You may from the editor execute

START TRANSACTION;

.. next do any number of operation from the Data Grid. It will not be saved to the table. Once you are sure that you want to update the table execute

COMMIT;

SQLyog will still send statements to the server for every row. But the server will not write them to the table – only to a log. On COMMIT the table gets updated. So only after COMMIT other clients will see what you have been doing.

Note that transactions require InnoDB tables and do not work with MyISAM. About transactions in MySQL read: http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-transactions.html

[Jason427]

'peterlaursen' wrote:

Let me add that what you should conisder to do here, is to use transactions. You may from the editor execute

START TRANSACTION;

.. next do any number of operation from the Data Grid. It will not be saved to the table. Once you are sure that you want to update the table execute

COMMIT;

SQLyog will still send statements to the server for every row. But the server will not write them to the table – only to a log. On COMMIT the table gets updated. So only after COMMIT other clients will see what you have been doing.

Note that transactions require InnoDB tables and do not work with MyISAM. About transactions in MySQL read: http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-transactions.html

Thank you that will be a big help

[Author]

Posts