Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE AutoUKTC;
- USE autouktc;
- CREATE TABLE cars (
- CarID INT AUTO_INCREMENT PRIMARY KEY,
- Make VARCHAR(100),
- Description VARCHAR(500),
- ImageLink VARCHAR(300),
- Milage INT
- );
- INSERT INTO cars
- VALUES (1, 'Opel Astra', 'Super car', 'https://images.ams.bg/images/galleries/109624/opel-astra-1460796459_big.jpg', 160054);
- INSERT INTO cars (Make, Description, ImageLink, Milage)
- VALUES ('Mercedes C220', 'German car', 'https://media.autoexpress.co.uk/image/private/s--ctJBoyrv--/v1579703511/autoexpress/2018/09/1_.jpg', 95630);
- DELETE FROM cars WHERE CarID = 1;
- SELECT * FROM cars;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement