Disable Update When Change Rows

[Jason427]

Currently YOG will update the table if you move off the row that was changed. I see this as a potential problem and would like to disable that. I would like to only have it save when I click the save button. Is there a way to do that?

[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