Re: Getting Error 1064(42000) when trying to do transaction processing in MySQL

[Ken Bond]

When I do them each as a separate statement, I get the message "Query Ok, 0 rows affected" immediately after entering the "Start TRANSACTION" statement. Immediately after entering the "INSERT INTO" and "VALUES" statements, I get the message "Query OK, 1 row affected", and immediately after entering the "COMMIT" statement, I get "Query OK, 0 rows affected".

If I admit the "INSERT INTO" and "VALUES" statement without the "Start Transaction" and "Commit" statements, I get the same result. So, my question is now...what's the importance of using the "Start Transaction" and "Commit" statements?