· 4 years ago · Apr 19, 2021, 11:20 AM
1
2@Tural_Asadov
3
4#############################################################################
5# MySQL / PHPMyAdmin Istifadesi. #
6# MANUAL MySQL kodu yazmag. #
7# DataBase,Tables,Columns yaratmag/ #
8# #
9#############################################################################
10
11INSERT Command:
12==========================================================================
13Tablonun adi : AdminAc
14
15
16CREATE TABLE IF NOT EXISTS Mysqladi(
17 id INT(11) AUTO_INCREMENT
18 ad VARCHAR(255),
19 soyad TEXT,
20 tarix DATE
21 sifre INT(11)
22 PRIMARY KEY(id)
23);
24+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
25Tablonun daxiline deyer elave etmek:
26
27INSERT INTO AdminAc(ad,soyad,tarix,sifre)VALUES('1','tural',asadov','2021-19-04','root')
28
29---------------------------------------------------------------------------------------------------
30
31Yenilemek guncellemek ucun:
32
33INSERT INTO AdminAc(id,ad,soyad,tarix,sifre)
34values('1','tural','asadov','2021-19-04','root')
35
36ON DUPLICATE KEY UPDATE tarix = '2021-19-04'
37
38
39INSERT INTO AdminAc(id,ad,soyad,tarix,sifre)
40values('1','tural','asadov','2021-19-04','root')
41
42ON DUPLICATE KEY UPDATE tarix = '2021-19-04'
43
44@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
45
46
47Select komutu : ( istediyinz deyeri size tegdim edecek:)
48
49SELECT id,ad FROM AdminAc
50SELECT * FROM 'AdminAc' WHERE 'tarix' 2021-19-04'
51
52&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
53
54and - ve demekdir or - ve ya demekdir. Sadece bu kodlarla bize sunmasini teqdim etmesini teleb edirik.
55
56SELECT * FROM AdminAc WHERE ad = 'tural' and id = '1' and tarix = '2021-19-04' (or) da istifade ede bilerik.
57
58___________________________________________________________________________________________________________________
59
60LimiT KuLLaNimi:
61
62
63
64SELECT * FROM 'AdminAc' LIMIT 2
65
66SELECT * FROM 'AdminAc' LIMIT 2, 4 (eger 1 4 yazsax 1 ile 4 arasindaki verileri getirer. 4 daxil olmaqla , eger 2 4 desek 3 ve 4 u getirecek.)
67
68SELECT * FROM 'AdminAc' WHERE ad = 'tural' LIMIT 2 ve ya 1 olsun. (eger tabloda verilermz sutunlarmzn sayi coxdursa bu komanda isledilmelidir.)
69
70$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
71
72NULL Parametri :
73
74SELECT * FROM 'AdminAc' WHERE ad IS NULL (hecbir veri gelmeyeck) NULL - 0 Sifir demekdir deyeri sifir demekdir.
75 eger ad sutununu NULL secersek NULL komadasini verdikde gelecekdir.
76
77SELECT * FROM 'AdminAc' WHERE ad IS NULL
78
79Basga bir yontem
80
81SELECT * FROM 'AdminAc' WHERE ad IS NOT NULL (NULL olmayanlari tegdim edecek)
82
83
84IN Kullanimi - In + icinde daxilinde demekdir. (prosesin icinde)
85
86SELECT * FROM 'AdminAc' WHERE ad IN ('tural')
87SELECT * FROM 'AdminAc' WHERE ad NOT IN ('tural')
88
89IN ve OR kullanimi eyni vezifeni yerine yedirir.
90
91BETWEEN - TARIX VE INTEGER arasnda isledilir ve tercumesi arasinda demekdir.
92
93SELECT * FROM 'AdminAc' WHERE hit BETWEEN 10 and 15 (TABLES VE COLUMNLARN SAYINA UYGUN HEREKET EDIN.)
94
95"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""'
96
97 ORDER BY Kullanimi:.
98
99SELECT * FROM 'AdminAc' ORDER BY ad asc
100SELECT * FROM 'AdminAc' ORDER BY id desc , hit asc (id isi boyuk olan ve hiti kicik olani getirdi.)
101asc - kicik olan verileri getirir.
102desc - boyuk olanlari deyeri boyukleri getirir/
103
104SELECT * FROM 'AdminAc' ORDER BY FIELD(hit,
105 17
106 15
107 12
108 )
109
110sizde hitler ne qederdirse onu qeyd edin. bu bir exampledir.
111
112:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
113
114 ALIAS Kullanimi :
115
116INSERT INTO istifadeciler (ad,soyad,mail,sifre) VALUES
117('tural',asadov','turalasad@gmail.com','12345'),
118('babali',vagif',babalivagif@gmail.com','123456')
119
120SELECT ad as a FROM Istifadeciler
121======================================================================
122
123UPDATE ve DELETE Kullanimi :
124
125Bir setirde ve butun setirde veri baza guncelleme yenileme /
126
127UPDATE istifadeciler SET ad = 'Babali', soyad'vagif'
128
129= deyer isaresidir.
130meselen ad in deyeri ad = 'babali'
131
132DELETE FROM Istifadeciler WHERE id =1 (ID si 1 olani sil eger bele komanda vermeseniz butun verileri silecek verilenler bazasi bosalacax/)
133^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
134
135SUM AVG COUNT MIN MAX kullanimi :
136
137SELECT MIN(hit) FROM AdminAc (AdminAc tablosunun minimum olan hiti getirir:)
138SELECT MAX(hit) FROM AdminAc (Maksimum getirdi:)
139<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
140
141
142
143
144
145
146
147
148