Guruh talabasi Boltaboyev Doniyor 7-variant Asaka zavodi

712.20-guruh talabasi Boltaboyev Doniyor
7-variant Asaka_zavodi

Nomi

Turi

ID

Nomer

Ish joyi

Office

Name

Data

ID

firmasi

color

Id

uskunalar

binolar

xodimlar

avtomobillar

Asaka_zavodi


ALTER TABLE avtomobile ADD ot_kuchi varchar(255);

INSERT INTO 'asaka_zavod'.'Avtomabile' ('ID', 'Name',' Color',' Data',' Firmasi',' Motor',’ot_kuchi’) VALUES (NULL, 'Captiva',’ Black',’2021-10-12', 'Chevrolet', '3.5',’5000’);

DELETE FROM ‘avtomabile’Where ID=’5’;

UPDATE ‘avtomabile’ SET Color=’red’, Name=’damas’ Where ID=3;

SELECT * FROM avtomabile

WHERE ID BETWEEN 2 AND 3;

SELECT * FROM avtomabile WHERE Name LIKE '%s';

SELECT * FROM avtomabile WHERE Color='red'AND Firmasi='chevrolet';

SELECT * FROM avtomabile WHERE Color='red' OR Color='blue';

SELECT * FROM avtomabile WHERE NOT Name='Lacetti';