api-practice-go/database/10_create.sql

15 lines
384 B
MySQL
Raw Permalink Normal View History

2023-11-25 17:29:17 -05:00
-- Script to create test DB.
create table album
(
id varchar(2) primary key not null,
title varchar(50),
artist varchar(50),
price decimal
);
insert into album
(id, title, artist, price)
values ('1', 'Blue Train', 'John Coltraine', 56.99),
('2', 'Jeru', 'Gerry Mulligan', 17.99),
('3', 'Sarah Vaughan and Clifford Brown', 'Sarah Vaughan', 39.99);