BkrpSzkh

1DROP TABLE IF EXISTS CARS;
2CREATE TABLE CARS(
3	ID INT NOT NULL AUTO_INCREMENT, 
4	BRAND VARCHAR(255) NOT NULL, 
5	MODEL VARCHAR(255), 
6	YEAR INT(4), 
7	CAR_NUMBER VARCHAR(10),
8	COLOR VARCHAR(255), 
9	PRIMARY KEY (ID)
10);
11
12INSERT INTO CARS (BRAND, MODEL, YEAR, CAR_NUMBER, COLOR) 
13	VALUES ('Ford', 'Focus', 2012, 'AA1234AA', 'RED');
14INSERT INTO CARS (BRAND, MODEL, YEAR, CAR_NUMBER, COLOR) 
15	VALUES ('Ford', 'Focus', 2015, 'AG0007JB', 'BLACK');
16INSERT INTO CARS (BRAND, MODEL, YEAR, CAR_NUMBER, COLOR) 
17	VALUES ('Opel', 'Astra', 2014, 'GE0450OP', 'RED');
18INSERT INTO CARS (BRAND, MODEL, YEAR, CAR_NUMBER, COLOR) 
19	VALUES ('BMW', 'M7', 2012, 'AP3333RK', 'GREEN');
20INSERT INTO CARS (BRAND, MODEL, YEAR, CAR_NUMBER, COLOR) 
21	VALUES ('BMW', 'M3', 2015, 'MW1245AA', 'WHITE');