トランザクションの操作

BEGIN [TRANSACTION [名前]] [ON CONFLICT 衝突時アルゴリズム]

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE prefecture_tbl_alter (
    id          integer,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl_alter SELECT *,0 AS group FROM prefecture_tbl;
DROP TABLE prefecture_tbl;
CREATE TEMPORARY TABLE prefecture_tbl (
    id          integer PRIMARY KEY,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl SELECT * FROM prefecture_tbl_alter;
END TRANSACTION;

END [TRANSACTION [名前]]

COMMIT [TRANSACTION [名前]]

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE prefecture_tbl_alter (
    id          integer,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl_alter SELECT *,0 AS group FROM prefecture_tbl;
DROP TABLE prefecture_tbl;
CREATE TEMPORARY TABLE prefecture_tbl (
    id          integer PRIMARY KEY,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl SELECT * FROM prefecture_tbl_alter;
COMMIT;

ROLLBACK [TRANSACTION [名前]]

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE prefecture_tbl_alter (
    id          integer,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl_alter SELECT *,0 AS group FROM prefecture_tbl;
DROP TABLE prefecture_tbl;
CREATE TEMPORARY TABLE prefecture_tbl (
    id          integer PRIMARY KEY,
    name        integer,
    group       integer
);
INSERT INTO prefecture_tbl SELECT * FROM prefecture_tbl_alter;
ROLLBACK;