deyanmalinov

03-mysql

Sep 19th, 2020 (edited)
171
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `people` (
  2.   `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  3.   `name` VARCHAR(200) NOT NULL,
  4.   `picture` BLOB NULL,
  5.   `height` DECIMAL(10,2) NULL,
  6.   `weight` DECIMAL(10,2) NULL,
  7.   `gender` CHAR(1) NOT NULL,
  8.   `birthdate` DATE NOT NULL,
  9.   `biography` LONGTEXT NULL
  10. );
  11.  
  12. INSERT INTO `people` (`id`, `name`, `height`, `weight`, `gender`, `birthdate`, `biography`)
  13. VALUES
  14. ('1', 'ivan', '156', '12', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
  15. ('2', 'stoqn', '4554', '45', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
  16. ('3', 'kolio', '5465', '74', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfssdfadfadsfadfadfadsfadfs'),
  17. ('4', 'pesho', '455', '45', 'm', '1989-10-10', 'sdfadfadsfadfadfadsfadfs'),
  18. ('5', 'goshka', '545', '45', 'f', '1989-10-10', 'sdfadfadsfadfadfadsfadfs');
RAW Paste Data