Database transaction test and CASCADE update CASCADE Delete

Database transactions

Start transaction; #开始事务

Insert into GZB (GZ) values (5000);

Insert into GZB (GZ) VALUES (6000);

Insert into GZB (GZ) values (7000);

Insert into GZB (GZ) values (8000); /* Perform the transaction and see if success data is added */

Commit # commit data to see if the data in the table is submitted

Rollback #数据库回滚

Cascade UPDATE, Cascade Delete

There are two main ways of

1. When building the table, add the on delete cascade/on update cascade after the FOREIGN KEY constraint

2. In client operation, select the table to Cascade, right click on Design Table---> FOREIGN key--->on delete/on update----> Double click to select Cascade

Database transaction test and CASCADE update CASCADE Delete