#!/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, 'otp', 50, 5.2),
(1, 'nar', 61, 48.1),
(2, 'bjs', 84, 80.2),
(3, 'vpy', 50, 54.5),
(4, 'kwx', 84, 17.1),
(5, 'iey', 2, 2),
(6, 'hla', 49, 86.8),
(7, 'bvg', 27, 79.6),
(8, 'wpa', 47, 88.9),
(9, 'pne', 6, 98.7),
(10, 'fon', 4, 5.3),
(11, 'oem', 24, 93.3),
(12, 'dxl', 65, 21.9),
(13, 'hdb', 7, 92.3),
(14, 'yqw', 30, 79.2),
(15, 'slu', 98, 74.8),
(16, 'rbl', 36, 73.6),
(17, 'wwg', 17, 28.1),
(18, 'jkp', 39, 71.9),
(19, 'ljo', 36, 77.4),
(20, 'vlw', 85, 75.8),
(21, 'wgh', 45, 70.6),
(22, 'vtz', 46, 10.4),
(23, 'nvv', 72, 63.7),
(24, 'quz', 81, 9.1),
(25, 'sgl', 21, 10.7),
(26, 'llg', 94, 54.9),
(27, 'mrs', 25, 74.9),
(28, 'mif', 99, 73.4),
(29, 'qgv', 47, 97.4);