sozdanie index v yazike sql

DOC 3 pages 1.6 MB Free download

3 pages

FaylHub.uz

Download via Telegram

Size 1.6 MB

File type DOC

Pages 3

Updated Dec 2025

Page preview (3 pages)

Scroll down 👇

1 / 3

tashkentskiy universitet informatsionnix texnologiy imeni muxammada al-xorazmiy prakticheskaya rabota №12 tema: sozdanie index v yazike sql distsiplina: baza dannix vipolnil : foziljonov mahmud potok : dbm205-2 tsel laboratornoy raboti: nauchitsya sozdavat ob'ekt sql index. kratkie teoreticheskie svedeniya: instruktsiya po sozdaniyu indeksa sql instruktsiya create index ispolzuetsya dlya sozdaniya indeksov v tablitsax. indeksi ispolzuyutsya dlya bistrogo izvlecheniya dannix iz bazi dannix. polzovateli ne vidyat indeksi, oni prosto ispolzuyutsya dlya uskoreniya poiskov/zaprosov. sintaksis indeksa sozdaet indeks dlya tablitsi. razresheni povtoryayushiesya znacheniya: create index index_name on table_name (column1, column2, ...); primer sozdaniya indeksa privedennaya nije instruktsiya sql sozdaet indeks s imenem "idks_lastname" v stolbtse "familiya" v tablitse "litsa": create index idx_lastname on persons (lastname); esli trebuetsya sozdat indeks dlya kombinatsii stolbtsov, mojno perechislit imena stolbtsov v skobkax, razdelennix zapyatimi: create index idx_pname on persons (lastname, firstname); instruktsiya drop index ispolzuetsya dlya udaleniya indeksa v tablitse. alter table table_name drop index index_name; affiliates. other …

2 / 3

ull_name); query ok, @ rows affected (0.02 sec) records: @ duplicates: @ warnings: @ mysql> show index from administrator; 4+--------------- +------------ 4+-------------------------- | table | non_unique | key_nam 4+--------------- +------------ + | administrator | 1 | index_name | administrator | 1 | index_name | administrator | 1 | index_name | administrator | 1 | 4+--------------- 4+------------ + 4 rows in set (0.01 mysql> create index error 1064 (42000): -> create index error 1064 (42000): index_administrator_date e index_dates on director(fio;) you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near '' at line 1 index_dates on director(fio); you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near ') create index index_dates on director(fio)' at line 1 mysql> desc director; +———— ++ …

3 / 3

== =f === == 1 | id [a | 3 | 2 | full_name [a | 5 3 | salary [a | 5 | 1 | full_name [a | 5 4+------------— 4+----------- 4+------------— + —----- 4+------------4--------- 4 --- === == -- === ull | index_type | comment | index_comment | visible 4+-----------— +--------— 4+--------------- +--------— es | btree | | | yes es | btree | | | yes es | btree | | | yes es | btree | | | yes —----- 4+------------4--------- 4 ----- === === $= === —-------- 4+--------------- + ---- === 4 -- == + comment | index_comment | visible | expression | —-------— 4--------------- + ---- === 4 -- = + | | yes | null | —-------- 4--------------- + ---- === 4 -- === + $---- === === + | expression | foo - === === + | null | | null | …

Want to read more?

Download all 3 pages for free via Telegram.

Download full file

About "sozdanie index v yazike sql"

tashkentskiy universitet informatsionnix texnologiy imeni muxammada al-xorazmiy prakticheskaya rabota №12 tema: sozdanie index v yazike sql distsiplina: baza dannix vipolnil : foziljonov mahmud potok : dbm205-2 tsel laboratornoy raboti: nauchitsya sozdavat ob'ekt sql index. kratkie teoreticheskie svedeniya: instruktsiya po sozdaniyu indeksa sql instruktsiya create index ispolzuetsya dlya sozdaniya indeksov v tablitsax. indeksi ispolzuyutsya dlya bistrogo izvlecheniya dannix iz bazi dannix. polzovateli ne vidyat indeksi, oni prosto ispolzuyutsya dlya uskoreniya poiskov/zaprosov. sintaksis indeksa sozdaet indeks dlya tablitsi. razresheni povtoryayushiesya znacheniya: create index index_name on table_name (column1, column2, ...); primer sozdaniya indeksa privedennaya nije instruktsiya sql soz...

This file contains 3 pages in DOC format (1.6 MB). To download "sozdanie index v yazike sql", click the Telegram button on the left.

Tags: sozdanie index v yazike sql DOC 3 pages Free download Telegram