Skip to content

Instantly share code, notes, and snippets.

@saltnlight5

saltnlight5/H2 Sample TEST table.sql

Created October 12, 2012 02:06
Show Gist options
  • Save saltnlight5/3876953 to your computer and use it in GitHub Desktop.
Save saltnlight5/3876953 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Demos
Raw
H2 Sample TEST table.sql
DROP TABLE IF EXISTS TEST;
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, 'World');
SELECT * FROM TEST ORDER BY ID;
UPDATE TEST SET NAME='Hi' WHERE ID=1;
DELETE FROM TEST WHERE ID=2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment