sql avto jadvali

DOCX 5 стр. 1,9 МБ Бесплатная загрузка

5 стр.

FaylHub.uz

Скачать через Telegram

Размер 1,9 МБ

Тип файла DOCX

Страницы 5

Обновлено Дек 2025

Предварительный просмотр (5 стр.)

Прокрутите вниз 👇

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.

Хотите читать дальше?

Скачайте все 5 страниц бесплатно через Telegram.

Скачать полный файл

О "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...

Этот файл содержит 5 стр. в формате DOCX (1,9 МБ). Чтобы скачать "sql avto jadvali", нажмите кнопку Telegram слева.

Теги: sql avto jadvali DOCX 5 стр. Бесплатная загрузка Telegram

sql avto jadvali

Предварительный просмотр (5 стр.)

Хотите читать дальше?

О "sql avto jadvali"

Похожие файлы