From b6009906d0359cfc44e7a8ef67371ab52f30aa00 Mon Sep 17 00:00:00 2001 From: Shulhan Date: Wed, 26 Nov 2025 10:36:23 +0700 Subject: tutorial: terjemahkan "Tutorial: Accessing a relational database" Tutorial asli ada di https://go.dev/doc/tutorial/database-access . --- .../database-access/data-access/create-tables.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 _content/doc/tutorial/database-access/data-access/create-tables.sql (limited to '_content/doc/tutorial/database-access/data-access/create-tables.sql') 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); -- cgit v1.3