vencinachev

SQL-DB-Cars-172

Dec 17th, 2020
850
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DATABASE autopark;
  2.  
  3. USE autopark;
  4.  
  5. CREATE TABLE cars (
  6. CarID INT AUTO_INCREMENT PRIMARY KEY,
  7. Make VARCHAR(50),
  8. Model VARCHAR(50),
  9. Description VARCHAR(200),
  10. Milage INT,
  11. ImageLink VARCHAR(500)
  12. );
  13.  
  14. INSERT INTO cars (Make, Model, Description, Milage, ImageLink)
  15. VALUES ('Skoda', 'Octavia', 'Super e, jena q e karala, garajna!', 160556, 'https://www.nastarta.com/wp-content/uploads/2019/11/2020-skoda-octavia-2-1.jpg');
  16.  
  17. INSERT INTO cars (Make, Model, Description, Milage, ImageLink)
  18. VALUES ('Opel', 'Astra', 'Ne gnie mnogo', 120546, 'https://upload.wikimedia.org/wikipedia/commons/thumb/0/04/Opel_Astra_G_front_20081128.jpg/1200px-Opel_Astra_G_front_20081128.jpg');
  19.  
  20.  
  21. SELECT * FROM cars;
  22.  
  23.  
  24.  
RAW Paste Data