Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `people` (
- `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(200) NOT NULL,
- `picture` BLOB NULL,
- `height` DECIMAL(10,2) NULL,
- `weight` DECIMAL(10,2) NULL,
- `gender` CHAR(1) NOT NULL,
- `birthdate` DATE NOT NULL,
- `biography` LONGTEXT NULL
- );
- INSERT INTO `people` (`id`, `name`, `height`, `weight`, `gender`, `birthdate`, `biography`)
- VALUES
- ('1', 'ivan', '156', '12', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
- ('2', 'stoqn', '4554', '45', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
- ('3', 'kolio', '5465', '74', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfssdfadfadsfadfadfadsfadfs'),
- ('4', 'pesho', '455', '45', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
- ('5', 'goshka', '545', '45', 'f', '1989-10-10', 'sdfadfadsfadfadfadsfadfs');
Add Comment
Please, Sign In to add comment