sql avto jadvali

DOCX 5 pages 1.9 MB Free download

Page preview (5 pages)

Scroll down 👇
1 / 5
2-laboratoriya ish guruh: sql001-l1 bajardi: tursinov sherzod 2- mavzu: sql da jadvallar va cheklovlar yaratish avto jadvalini postgresql yordamida yaratdik . avto jadvalidagi price ustunini numericga o’zgartirdik company_name ustuniga default qiymat sifatida gm uzbekistan kompaniyasi nomini berib qo’ydik. name ustunini unique qilib o’zgartirdik. jadvalga ma’lumot kirtdik. e’tibor bersangiz biz company_name ustuniga hech qanday qiymat kiritmasak ham hech qanday error qaytarmadi buning sababi biz bu ustunni default value berib qo’yganimiz uchun default qiymat sifatida gmuzbekistanni olib ketadi. bu yerda bir xil id ga ega bo’lgan ma’lumot kiritmoqchi bo’lganimizda id ustuni primary key bo’lgani uchun error qaytardi. bu yerda esa bir xil nomga ega bo’lgan laptopni kiritmoqchi bo’lganimizda name unique bo’lganligi uchun error qaytardi. select buyrug’idan foydalanib jadvalimizni ekranga chiqardik. drop buyrug’i yordamida jadvalimizni o’chirib yubordik. image6.png image7.png image8.png image9.png image1.png image2.png image3.png image4.png image5.png §p paadmin 4 (e\admin fite~ objecty toolsv browser sb qo v & servers (1) v @ postgresql …
2 / 5
s v = sqltatu > casts & catalogs (© event triggers '® extensions > > foreign data wrappers & languages © publications ®& schemas (1) > ~ subscriptions > & login/group roles > &, tablespaces help v properties sql statistics dependencies dependents §§ sql_tatu/postgres@postgresql 14* & @@y s&s qy by hi bd hy yo v noimt v py & by & 3 @ £ by el sql_tatu/postgres@postgresql 14 v query editor query history scratch pad x insert into avto(id,name,price,speed) values ( | 1 2 3, 3 'tracker', 4 30000, 5 260 6 3 data output explain messages notifications error: oumbka: nostopswyeeca shavehue knio4a hapywaet orpahuyehne yhukanbhocth "unt detail: kniou "(name)=(tracker)" ye cywecteyer. sql state: 23505 §p paadmin 4 (e\admin filer objecty toolsy helpy browser sb. q_>>_ properties sql statistics dependencies dependents § sql_tatu/postgres@postgresql 14* x v & servers (1) ss @aary & qy by & td by vy v. nnolimt …
3 / 5
| 1 drop table avto; 2 > (© event triggers > ® extensions foreign data wrappers > & languages > © publications > & schemas (1) > ~ subscriptions > & login/group roles > &, tablespaces data output explain messages notifications drop table query returned successfully in 78 msec. y query returned successfully in 78 msec. §p paadmin 4 (e\admin filer objecty toolsy helpy browser sb. q_>>_ properties sql statistics dependencies dependents § sql_tatu/postgres@postgresql 14* x v & servers (1) s @ary 8 qy by & td by vy ov. nolimt v py wer = 3 @ & by 1 sp ocmme sql_tatu/postgres@postgresql 14 v v & databases (2) 3s | sal taw/postares@postg scratch pad x query editor query history > & postgres v = sqltatu | 1 create table avto ( > b casts 2 id integer not null primary key, > & catalogs 3 name varchar (25), 4 …
4 / 5
sb. q_>>_ properties sql statistics dependencies dependents § sql_tatu/postgres@postgresql 14* v & servers (1) s = ay &§ qy bvt td gy vy v.) noimt v bp y w br s33 @ £ by v gp postgresau 14 g postgresa | & [sa tatu/postgres@postgresql 14 v x vv & databases (2) . : query editor query history scratch pad > & postgres | 1 alter table avto alter column company_name set default 'gm uzbekistan'; v = sqltatu > casts > & catalogs > (© event triggers > ® extensions foreign data wrappers > & languages > © publications > & schemas (1) > ~ subscriptions > & login/group roles > &, tablespaces data output explain messages notifications alter table query returned successfully in 49 msec. y query returned successfully in 49 msec. §p paadmin 4 (e\admin filer objecty toolsy helpy browser sb. q_>>_ properties sql statistics dependencies dependents § sql_tatu/postgres@postgresql …
5 / 5
)3 foreign data wrappers > & languages > © publications > & schemas (1) > ~ subscriptions > & login/group roles > &, tablespaces data output explain messages notifications insert © 1 query returned successfully in 41 msec. y query returned successfully in 41 msec.

Want to read more?

Download all 5 pages for free via Telegram.

Download full file

About "sql avto jadvali"

2-laboratoriya ish guruh: sql001-l1 bajardi: tursinov sherzod 2- mavzu: sql da jadvallar va cheklovlar yaratish avto jadvalini postgresql yordamida yaratdik . avto jadvalidagi price ustunini numericga o’zgartirdik company_name ustuniga default qiymat sifatida gm uzbekistan kompaniyasi nomini berib qo’ydik. name ustunini unique qilib o’zgartirdik. jadvalga ma’lumot kirtdik. e’tibor bersangiz biz company_name ustuniga hech qanday qiymat kiritmasak ham hech qanday error qaytarmadi buning sababi biz bu ustunni default value berib qo’yganimiz uchun default qiymat sifatida gmuzbekistanni olib ketadi. bu yerda bir xil id ga ega bo’lgan ma’lumot kiritmoqchi bo’lganimizda id ustuni primary key bo’lgani uchun error qaytardi. bu yerda esa bir xil nomga ega bo’lgan laptopni kiritmoqchi bo’lganimizda n...

This file contains 5 pages in DOCX format (1.9 MB). To download "sql avto jadvali", click the Telegram button on the left.

Tags: sql avto jadvali DOCX 5 pages Free download Telegram