MySQL : set autocommit=0;
| From: | Chris Lee | Date: | Mon, 20 Nov 2000 09:53:52 +0000 |
| Subject: | MySQL : set autocommit=0; | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-26367@lists.php.net to get a copy of this message | ||
So I was reading the mysql manual, which I am not impressed with in this
area... It was saying to use rollback function's (I didnt know these were
in MySQL) that I have to do
SET AUTOCOMMIT=0;
BEGIN;
UPDATE product SET var = '123' WHERE var = '';
COMMIT;
well all I got was
ERROR 1036: Table 'product' is read only
now I can't get rid of this, anywhere.....
SET AUTOCOMMIT=1;
doesnt do anything. Any idea's
Chris Lee