SQLiteチュートリアル(V): データベースとトランザクション

    sqlite> CREATE TABLE testtable (first_col integer);
    sqlite> INSERT INTO testtable VALUES(1);
    sqlite> .backup 'D:/mydb.db' -- Back up the primary database in the current connection to the specified file.
    sqlite> .exit
    -- Relogin the sqlite command line tool at.
    sqlite> CREATE TABLE testtable (first_col integer);
    sqlite> INSERT INTO testtable VALUES(2);
    sqlite> INSERT INTO testtable VALUES(1);
    sqlite> ATTACH DATABASE 'D:/mydb.db' AS mydb;   
    sqlite> .header on -- Query results output field names as headers.
    sqlite> .mode column -- Display each column separately.
    sqlite> SELECT t1.first_col FROM testtable t1, mydb.testtable t2 WHERE t.first_col = t2.first_col;
    first_col
    ----------
    1   

    -- This example hosts the result of the above example, i.e. the mydb database has been attached to the current connection.
    sqlite> DETACH DATABASE mydb;
    sqlite> SELECT t1.first_col FROM testtable t1, mydb.testtable t2 WHERE t.first_col = t2.first_col;
    Error: no such table: mydb.testtable

    sqlite> BEGIN TRANSACTION;
    sqlite> INSERT INTO testtable VALUES(1);
    sqlite> INSERT INTO testtable VALUES(2);
    sqlite> COMMIT TRANSACTION; -- shows that the transaction was committed and the data in the data table was changed.
    sqlite> SELECT COUNT(*) FROM testtable;
    COUNT(*)
    ----------
    2
    sqlite> BEGIN TRANSACTION;
    sqlite> INSERT INTO testtable VALUES(1);
    sqlite> ROLLBACK TRANSACTION; -- shows that the transaction was rolled back with no changes to the data in the data table.
    sqlite> SELECT COUNT(*) FROM testtable;
    COUNT(*)
    ----------
    2