java -cp C:\Wintools\h2\bin\h2-2.4.240.jar org.h2.tools.Shell -url jdbc:h2:C:/usr/dbms/h2/testdb -user testuser -password testpass

sql>RUNSCRIPT FROM './tables/item_categories.sql';
sql>RUNSCRIPT FROM './tables/items.sql';

java -cp C:\Wintools\h2\bin\h2-2.4.240.jar org.h2.tools.Server -tcp -tcpPassword ShutDownPass123 -ifExists

java -cp C:\Wintools\h2\bin\h2-2.4.240.jar org.h2.tools.Server -tcpShutdown "tcp://localhost" -tcpPassword ShutDownPass123

java -cp C:\Wintools\h2\bin\h2-2.4.240.jar org.h2.tools.Shell -url jdbc:h2:tcp://localhost/./stdb -user testuser -password testpass

java -cp C:\Wintools\h2\bin\h2-2.4.240.jar org.h2.tools.RunScript ^
  -url jdbc:h2:C:/usr/dbms/h2/database/testdb -user testuser -password testpass -script items.sql -showResults

UDATE TIMESTAMP GENERATED ALWAYS CURRENT_TIMESTAMP

CDATE TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

INSERT INTO ITEMS(ITEM_NAME,CATEGORY_ID,SIZE_DESC,PRICE,MAKER_DESC,NOTES,DISPLAY_ORDER)
 SELECT * FROM CSVREAD('./tables/items.dat', NULL, 'UTF-8', CHR(9))

INSERT INTO ITEMS(ITEM_NAME,CATEGORY_ID,SIZE_DESC,PRICE,MAKER_DESC,NOTES,DISPLAY_ORDER)
 SELECT * FROM CSVREAD('./tables/items.dat', NULL, 'charset=UTF-8 fieldSeparator=|')

SELECT MAX(CAST(EMPLOYEE_NUM AS INT)), MIN(CAST(EMPLOYEE_NUM AS INT)), SUM(CAST(EMPLOYEE_NUM AS INT))
  FROM CSVREAD('C:/usr/dbms/csv/csvdb/shiten.dat', null, 'UTF-8', CHAR(9))
 WHERE AREA_CODE = '5'

public static void main(String args[]) {
    Connection conn = null;
    Statement stmt = null;

    try {
        Class.forName("org.h2.Driver");
        conn = DriverManager.getConnection("jdbc:h2:mem:");
        System.out.println("connected.");

        stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery(
                "SELECT SHITEN_NAME, ADDRESS, EMPLOYEE_NUM " +
                  " FROM CSVREAD('C:/usr/dbms/csv/csvdb/shiten.dat', null, 'UTF-8', CHAR(9)) " +
                  "WHERE AREA_CODE = '5' ORDER BY CAST(EMPLOYEE_NUM AS INT) DESC");
        while (rset.next()){
            System.out.println(rset.getString(1) + "\t" + rset.getString(2) + "\t" + rset.getString(3));
        }
        rset.close();
    } catch(Exception ex) {
        ex.printStackTrace();
    } finally {
        try {
            stmt.close();
            conn.close();
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
    }
}

public static void main(String args[]) throws SQLException {
    Csv csv = new Csv();
    csv.setFieldSeparatorRead('\t');
    ResultSet rs = csv.read("C:/usr/dbms/csv/csvdb/shiten.dat", null, "UTF-8");
    ResultSetMetaData meta = rs.getMetaData();
    while (rs.next()) {
        for (int i = 0; i < meta.getColumnCount(); i++) {
            System.out.println(meta.getColumnLabel(i + 1) + ": " + rs.getString(i + 1));
        }
        System.out.println();
    }
    rs.close();
}

CREATE TABLE SCORES(
  NAME VARCHAR NOT NULL PRIMARY KEY,
  SCORE INTEGER
)

INSERT INTO SCORES(NAME,SCORE) VALUES ('Taro', 90)
更新数:1

INSERT INTO SCORES(NAME,SCORE) VALUES ('Jiro', 85)
更新数:1

INSERT INTO SCORES(NAME,SCORE) VALUES ('Taro', 93)
ユニークインデックスまたはプライマリキー違反（エラー）

MERGE INTO SCORES USING DUAL ON NAME = 'Taro'
 WHEN MATCHED THEN UPDATE SET SCORE = 93
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES ('Taro', 93)
更新数:1 (Updateが実行された)

MERGE INTO SCORES USING DUAL ON NAME = 'Saburo'
 WHEN MATCHED THEN UPDATE SET SCORE = 81
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES ('Saburo', 81)
更新数:1 (Insertが実行された)

MERGE INTO SCORES USING DUAL ON NAME = 'Taro'
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES ('Taro', 94)
更新数:0 (該当行が既にあれば何もしないので)

MERGE INTO SCORES USING DUAL ON NAME = 'Goro'
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES ('Goro', 82)
更新数:1 (Insertが実行された)

MERGE INTO SCORES a USING (SELECT 'Taro' AS NAME, 94 AS SCORE) newrec ON a.NAME = newrec.NAME
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES (newrec.NAME, newrec.SCORE)
更新数:0 (該当行が既にあれば何もしないので)

MERGE INTO SCORES a USING (SELECT 'Goro' AS NAME, 82 AS SCORE) newrec ON a.NAME = newrec.NAME
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES (newrec.NAME, newrec.SCORE)
更新数:1 (Insertが実行された)

MERGE INTO SCORES a USING (SELECT ? AS NAME, ? AS SCORE) newrec ON a.NAME = newrec.NAME
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES (newrec.NAME, newrec.SCORE)

MERGE INTO SCORES a USING (SELECT CAST(? AS VARCHAR) AS NAME, CAST(? AS INT) AS SCORE) newrec ON a.NAME = newrec.NAME
 WHEN NOT MATCHED THEN INSERT (NAME,SCORE) VALUES (newrec.NAME, newrec.SCORE)