11-mavzu. Pythonda PostgreSQL yordamida ma’lumotlarni yangilash

PostgreSQLda ma’lumotlarni yangilash operatorini tanlang.

• update

• select

• insert into

• primary key

Nuqtalar o'rniga mos kalit so'zni kiriting?

UPDATE jadval_nomi ... ismi='Akmal'

WHERE id=5;

(a)  

Nuqtalar o'rniga mos kalit so'zni kiriting?

... jadval_nomi SET ismi='Akmal'

WHERE id=5;

(a)  

yoshi 50 dan kattalarni maoshi 20 foizga oshish so'rivini tanlang?.

• update set talaba maoshi = maoshi*1.2 where yoshi>50;

• update set talaba maoshi = maoshi*1.2 where yoshi>=50;

• update set talaba where yoshi>50;

• update set talaba maoshi = maoshi*1.2;

barchaning maoshi 20 foizga oshish so'rivini tanlang?

• update set talaba maoshi = maoshi*1.2 where yoshi>50;

• update set talaba maoshi = maoshi*1.2 where yoshi>=50;

• update set talaba where yoshi>50;

• update set talaba maoshi = maoshi*1.2;

UPDATE so‘rovining vazifasi nimadan iborat?

• jadvaldan barcha ma’lumotlarni chiqarish

• jadval ichidagi qiymаtlаrini o‘zgаrtirish uchun

• jadvaldan barcha ma’lumotlarni o‘chirish

• jadvaldagi berilgan ustunni tartiblash

UPDATE person SET email=...;

email ustuniga bo'shq qiymat(lar) kiriting;

(a)  

UPDATE talaba

... name='Javlon'

WHERE country='Uzbekistan';

Nuqtalar o'rniga mos so'zni kiriting?

(a)  

UPDATE talaba

SET country='Uzbekistan';

WHERE email = ...

Nuqtalar o'rniga emaili ' (a)   .uz' bo'lgan satrlarni almashtirish amalga oshirilsin?

SQL tilida belgilar to'plami tipi qanday?

• INT

• VARCHAR

• BIGSERIAL

• DATE