CS479/579 - Web Programming II

Displaying ./code/SQL/table.sql

-- id  A    B   C
-- 0  foo  1  5.0
-- 1  bar  3  2.0
-- 2  baz  5  1.5

DROP TABLE IF EXISTS `tablename`;

create table `tablename` (
  `id`  INT,
  `A`   VARCHAR(32),
  `B`   INT,
  `C`   FLOAT
);

INSERT INTO tablename (`id`, `A`, `B`, `C`)
 VALUES
  (0, 'foo', 1, 5.0),
  (1, 'bar', 3, 2.0),
  (2, 'baz', 5, 1.5)
;