Performing transactions

Create dummy tables and sample data to understand this recipe:

mysql> CREATE DATABASE bank;mysql> USE bank;mysql> CREATE TABLE account(account_number varchar(10) PRIMARY KEY, balance int);mysql> INSERT INTO account VALUES('A',600),('B',400);

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.