one more question, how about when i'm using 'BEGIN'
and doesn't end it with 'COMMIT' neither 'ROLLBACK'
what will happen.
I've tried before and nothing happen but does anyone have an opinion?
This depends on a number of things:
If the table handler in question does not support transactions (like MyIsam), all statements are commited as they are executed, regardless of BEGIN/COMMIT/ROLLBACK (those are just ignored by the table handler).
If the table handler supports transactions, then if the client disconnects or the server goes down, a ROLLBACK is effectively executed serverside, all changes are ignored by the server.
If the server is still up, and the client is still connected, well, then the transaction is still active, and it is not yet defined if the changes will be commited or not... this is a bit like Schroedingers cat... ;)
-- Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
