Advertisement
Nikitalox

LR6-Inserts

Jun 13th, 2024
905
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.34 KB | None | 0 0
  1. -- Data for table `hard_drive_db`.`serial_numbers`
  2. -- -----------------------------------------------------
  3. START TRANSACTION;
  4. USE `hard_drive_db`;
  5. INSERT INTO `hard_drive_db`.`serial_numbers` (`serial_number`, `model`) VALUES ('1010101', 'SHIRAKAVA');
  6. INSERT INTO `hard_drive_db`.`serial_numbers` (`serial_number`, `model`) VALUES ('202020202', 'KAGEYAMA');
  7.  
  8. COMMIT;
  9.  
  10.  
  11. -- -----------------------------------------------------
  12. -- Data for table `hard_drive_db`.`producer`
  13. -- -----------------------------------------------------
  14. START TRANSACTION;
  15. USE `hard_drive_db`;
  16. INSERT INTO `hard_drive_db`.`producer` (`name_producer`, `web-site`) VALUES ('TOSHIBA', 'TOSHIBA.com');
  17. INSERT INTO `hard_drive_db`.`producer` (`name_producer`, `web-site`) VALUES ('WD Purple', 'Purple.com');
  18.  
  19. COMMIT;
  20.  
  21.  
  22. -- -----------------------------------------------------
  23. -- Data for table `hard_drive_db`.`characteristics`
  24. -- -----------------------------------------------------
  25. START TRANSACTION;
  26. USE `hard_drive_db`;
  27. INSERT INTO `hard_drive_db`.`characteristics` (`model`, `name_producer`, `volume`, `rotation_speed`, `interface`) VALUES ('KAGEYAMA', 'TOSHIBA', '100', '2000', 'TCP');
  28. INSERT INTO `hard_drive_db`.`characteristics` (`model`, `name_producer`, `volume`, `rotation_speed`, `interface`) VALUES ('SHIRAKAVA', 'WD Purple', '200', '2000', 'TCP');
  29.  
  30. COMMIT;
  31.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement