`supermarket`


Download 0.66 Mb.
bet1/7
Sana25.11.2020
Hajmi0.66 Mb.
  1   2   3   4   5   6   7

4. CREATE TABLE `supermarket`.`mahsulot1` ( `id` INT(30NOT NULL AUTO_INCREMENT , `nomi`VARCHAR(30NOT NULL , `narx` INT(50NOT NULL , `keltirilgan_sana` DATE NOT NULL ,`miqdor` INT(30NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;



INSERT INTO `mahsulot1` (`id``nomi``narx``keltirilgan_sana``miqdor`VALUES (NULL,'non''3000''2020-11-19''200'), (NULL'NesCofee GOLD''35000''2020-11-01','100'), (NULL'Go\'sht''75000''2020-11-17''400'), (NULL'Pomidor''10000''2020-11-03''200'), (NULL'\"Zatlya\" Simechka yog\'''80000''2020-11-01''50'), (NULL,'Un''220000''2020-11-03''320')



Download 0.66 Mb.

Do'stlaringiz bilan baham:
  1   2   3   4   5   6   7




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2020
ma'muriyatiga murojaat qiling