CREATE TABLE IF NOT EXICTS Diseaes(

Download 1.41 Mb.
bet	2/4
Sana	27.01.2023
Hajmi	1.41 Mb.
	#39841

1 2 3 4

Bog'liq
410-21 RamazonovUmrzoq
30. Konstruksion materiallar texnologiyasi. Mirboboyev V.A, 1.Psixologiya fanining predmeti, maqsad va vazifalari, moliya va fiskal siyosati, Behzod

CREATE TABLE IF NOT EXICTS Diseaes(
Id INT NOT NULL AUTO_INCREMENT,
Registration_date DATE NOT NULL,
Diseaes_name varchar(30) NOT NULL,
Primary Key(id)
);

3-rasm.Diseaes jadvali
Keyin esa bu jadvalga kasalliklar nomlari,ro’yxatga olingan sanasiga oid ma’lumotlar kiritamiz.
INSERT INTO `Diseaes` (`parent_id`, `id`, `registration_date`,
`diseaes_name`) VALUES
(NULL, 1, '2019-11-19', 'coronavirus'),
(NULL, 2, '2016-07-19', 'sinusit'),
(NULL, 3, '2022-10-05', 'migren'),
(NULL, 4, '2022-06-28', 'leykoz'),
(NULL, 5, '2022-11-07', 'sariq kasal'),
(1, 6, '2022-09-21', 'Coronavirus Covid 19');
Endi esa Bemorlar degan ma’lumotlar bazasi yaratamiz.
CREATE TABLE `Diseaseds` (
`Id` int NOT NULL,
`name` varchar(30) NOT NULL,
`Diseased_date` date NOT NULL,
`med_history` varchar(25) NOT NULL,
`diagnosis` varchar(30) NOT NULL,
Primary Key(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Bu yaratgan jadvalga ma’lumot kiritamiz.
INSERT INTO `Diseaseds` (`Id`, `name`, `Diseased_date`, `med_history`, `diagnosis`) VALUES
(1, 'Ali Valiyev', '2022-07-19', ' yallig\'lanish', 'sinusit'),
(2, 'Akrom Jurayev', '2022-10-05', 'bosh og\'rig\'i', 'migren'),
(3, 'Elbek Hasanov', '2022-06-28', 'o\'sma kasalligi', 'leykoz'),

Download 1.41 Mb.

1 2 3 4

Download 1.41 Mb.