#!/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, 'tyi', 50, 97.4),
(1, 'uyk', 22, 64.5),
(2, 'fgy', 72, 50.3),
(3, 'vay', 35, 53.2),
(4, 'chl', 86, 85.5),
(5, 'lqd', 9, 59.9),
(6, 'tsw', 2, 7.3),
(7, 'afq', 75, 33.8),
(8, 'pvk', 66, 96.4),
(9, 'pcq', 68, 81),
(10, 'lyd', 84, 15.4),
(11, 'amk', 56, 48.5),
(12, 'nps', 67, 71.5),
(13, 'wnr', 51, 78.3),
(14, 'kdu', 17, 87.4),
(15, 'zqv', 74, 16),
(16, 'phs', 73, 46.9),
(17, 'arl', 6, 73.4),
(18, 'xtu', 76, 0.8),
(19, 'vym', 96, 94.6),
(20, 'pis', 65, 2),
(21, 'zvb', 65, 90.4),
(22, 'ebg', 61, 50.9),
(23, 'bnp', 55, 40.9),
(24, 'ady', 47, 80.7),
(25, 'yjt', 18, 43.1),
(26, 'fvr', 72, 72.2),
(27, 'cfs', 80, 14.7),
(28, 'muv', 16, 26.7),
(29, 'pwy', 52, 64.1);