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


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