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;