Start a TRANSACTION : TRANSACTION COMMIT « Transaction « SQL / MySQL






Start a TRANSACTION

      


CREATE TABLE table1(colA INTEGER, colB INTEGER);

START TRANSACTION;

UPDATE table1
SET colB=11 WHERE colA=1;

COMMIT;


drop table table1;

   
    
    
    
    
    
  








Related examples in the same category

1.Using TRANSACTION and COMMIT