Nomidagi toshkent axborot texnalogiyalari universiteti

desc maxsulot_bazasi; desc ishlatilishi; Natija:




Insert buyrug’i yordamida mavjud jadvallarga ma’lumotlar kiritamiz va select buyrug’i yordamida natijani ko’ramiz:


^mysql> iuz ^{er t undo maxsuloi va9uesCl. ’olrñn 'D:}

mysql> insert into maxsu9or vaJues(Z,'kumosh_tukuni

Query oK, i row affected \o.o5 sec}
nysq1> i nse r c In to maxsu1at vat ues 3, ' VIII S KuKun 1 } :
Qu e ry o< , 1 row a1°'teczed CO . O4 sect
mysql inserr into maxsu]or vaflues(4, ’remir _va_D ^'j;

mysql select from maxsulot;

Id | maxsu1at nom1
1 1 I ol ii n I
1 2 I k umu sh_zukunl I
3 md s_kukun1

4 rows 1n set {D. OO sect

mysqlx
query
my s q1 > insert
qurilma valuesQi,’jagli maydalagich’j;
affected QO.Od sect
n to go r 5 d ma vat u es (2, ' kon u s d 5 pmayda fl ag 5 c h ' ) ablecbeci (O . O4 s e c:)
1 n to qu r 11 ma 'u'a1 u e s ¿3 , ' ga 1 v i r ' g ;

Que c y OK ,

mysql query

Que r"y
i row affected QO.O5 sect
n to qu of 1 ma va1 ue s ¿4, ' sha r 11_ce gi rmon g

n to qu of 1 ma vat ue s ¿ 5, ' bar ab an 11 deg i Oman ' g ; a f'1°ec be d ¿O .0 5 sect

my sql > Query
insert into quri]ma va7uesQ6,’f7otatsion_mashina’j
on, i row affected QO.05 sect

my s q1 > i nsert 1n to qu r 11ma 'u'a1 u e s ¿7, ' p e c h ' g
Qu er y OK , i row affected QO.O5 sect
mysql> select • from qurilma;
i cl | qu r 1 1 ma_n am i