H2 Console - Sample SQL Script

개요

-- Delete the table if it exists
DROP TABLE IF EXISTS TEST;

-- Create a new table with ID and NAME columns
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));

-- Add a new row
INSERT INTO TEST VALUES(1, 'Hello');

-- Add another row
INSERT INTO TEST VALUES(2, 'World');

-- Query the table
SELECT * FROM TEST ORDER BY ID;

-- Change data in a row
UPDATE TEST SET NAME='Hi' WHERE ID=1;

-- Remove a row
DELETE FROM TEST WHERE ID=2;