#!/usr/bin/php

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, 'xkg', 52, 16),
(1, 'mni', 45, 96.3),
(2, 'ncy', 48, 5.3),
(3, 'gbe', 11, 56.9),
(4, 'ozj', 2, 92.9),
(5, 'iwr', 63, 9.5),
(6, 'nez', 20, 14.5),
(7, 'wzk', 2, 1.6),
(8, 'pmb', 70, 84.3),
(9, 'gzv', 96, 37.6),
(10, 'igr', 37, 93.3),
(11, 'qmt', 90, 68.2),
(12, 'xsh', 97, 4.2),
(13, 'anc', 14, 28.9),
(14, 'mcx', 77, 50.7),
(15, 'urs', 77, 20.5),
(16, 'twg', 94, 71.5),
(17, 'del', 63, 54.6),
(18, 'vdk', 60, 8.2),
(19, 'gos', 26, 50.8),
(20, 'kla', 23, 93.2),
(21, 'ack', 56, 66.3),
(22, 'ahd', 19, 69.1),
(23, 'jll', 75, 26),
(24, 'skx', 34, 70),
(25, 'fxk', 73, 60.3),
(26, 'fow', 42, 16.1),
(27, 'fvi', 45, 48.8),
(28, 'xth', 98, 95.4),
(29, 'tkw', 92, 52.4);