diff options
Diffstat (limited to '_content/doc/tutorial/database-access/data-access/create-tables.sql')
| -rw-r--r-- | _content/doc/tutorial/database-access/data-access/create-tables.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/_content/doc/tutorial/database-access/data-access/create-tables.sql b/_content/doc/tutorial/database-access/data-access/create-tables.sql new file mode 100644 index 0000000..63290a0 --- /dev/null +++ b/_content/doc/tutorial/database-access/data-access/create-tables.sql @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS album; +CREATE TABLE album ( + id SERIAL, + title VARCHAR(128) NOT NULL, + artist VARCHAR(255) NOT NULL, + price DECIMAL(5,2) NOT NULL, + PRIMARY KEY (id) +); + +INSERT INTO album + (title, artist, price) +VALUES + ('Blue Train', 'John Coltrane', 56.99), + ('Giant Steps', 'John Coltrane', 63.99), + ('Jeru', 'Gerry Mulligan', 17.99), + ('Sarah Vaughan', 'Sarah Vaughan', 34.98); |
