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

[Barry Galbraith]

Each is a separate statement.

mysql> START TRANSACTION;

mysql> INSERT INTO ServicePlans(PlanID,PlanName,PlanDescription,PlanPrice,DiscountedPrice)
    -> VALUES('C1001','TeleComm Course','Course on Telecommunications',45.00,35.00);

mysql> COMMIT;

Good luck,
Barry.