1-qadam create database Bank

1-qadam create database Bank

create
table Bank (
id integer primary key not null,
FISH varchar (30) not null,
Manzil varchar (30) not null,
tel_num varchar (30) not null,
lavozim varchar (30) not null,
yosh varchar (30) not null

)

2-qadam jadvalga ma’lumot qo’shish
insert into Bank
values(
10,
'Davronov Diyorbek',
'Navoiy',
'[phone]',
'yetakchi',
'21'

)

3-qadam jadvalga yangi ustun qo’shish
Alter table Bank add jinsi date --- shu kalit so’zi orqali yangi ustun qo’shiladi.

Natija:

4 – qadam qo’shilgan ustunga ma’lumot qo’shish
Alter table Bank alter column jinsi type varchar;
Update Bank set jinsi = ‘ayol’ where id=1


5 – qadam yaratilgan jadvaldan biror ustunni olib tashlash
alter table Bank drop lavozim

6 – qadam yaratilgan jadvaldan biror qatorni olib tashlash

Delete from Bank
Where tel_num = ‘[phone]’

7 – natija jadvalni chop etish

XULOSA
Men labaratoriya ishini bajarib jadvalga yangi ustun, qator qo’shishni. Shu qatorda o’chirishni o’rgandim va yangi ma’lumotlar kiritishni ham bilib oldim.