tutorial: terjemahkan "Tutorial: Accessing a relational database"

Tutorial asli ada di https://go.dev/doc/tutorial/database-access .

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);