Bloglar | MySQL(i), PDO bo'yicha | SQL sintaksisi
SQL – sintaksisi
SQL-ga Syntax deb ataladigan yagona qoidalar va ko'rsatmalar to'plami amal qiladi. Ushbu dars sizga barcha asosiy SQL sintaksisini kiritish orqali SQL bilan tez boshlanish imkonini beradi.
Barcha SQL so'rovlari SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW kabi barcha kalit so'zlardan boshlanadi va barcha so'zlar nuqta-vergul (;) bilan yakunlanadi.
Bu erda ta'kidlanish kerak bo'lgan eng muhim nuqta - bu SELECT degan ma'noni anglatadi va SQL iboralarida bir xil ma'noga ega SQL deganidir. Holbuki, MySQL jadval nomlarida farq qiladi. Shunday qilib, MySQL bilan ishlayotgan bo'lsangiz, ma'lumotlar bazasida mavjud bo'lgan jadval nomlarini berishingiz kerak.
SQLda turli xil sintaksis
Ushbu qo'llanmada berilgan barcha misollar MySQL-server bilan sinab ko'rilgan.
SQL SELECT bayonoti
Namuna:
SELECT column1, column2....columnN
FROM table_name;

SQL DISTINCT Clause
Namuna:
SELECTDISTINCT column1, column2....columnN
FROM table_name;

SQL WHERE Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION;

SQL AND/OR Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION-1 {AND|OR} CONDITION-2;

SQL IN Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE column_name IN (val-1, val-2,...val-N);

SQL BETWEEN Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE column_name BETWEEN val-1AND val-2;
SQL LIKE Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE column_name LIKE { PATTERN };
SQL ORDER BY Clause
Namuna:
SELECT column1, column2....columnN
FROM table_name
WHERE CONDITION
ORDERBY column_name {ASC|DESC};
SQL GROUP BY Clause
Namuna:
SELECTSUM(column_name)
FROM table_name
WHERE CONDITION
GROUPBY column_name;
SQL COUNT Clause
Namuna:
SELECTCOUNT(column_name)
FROM table_name
WHERE CONDITION;
SQL HAVING Clause
Namuna:
SELECTSUM(column_name)
FROM table_name
WHERE CONDITION
GROUPBY column_name
HAVING (arithematic function condition);
SQL CREATE TABLE Statement
Namuna:
CREATETABLE table_name(
column1 dаtаtype,
column2 dаtаtype,
column3 dаtаtype,
.....
columnN dаtаtype,
PRIMARY KEY( one or more columns )
);
SQL DROP TABLE Statement
Namuna:
DROPTABLE table_name
SQL CREATE INDEX Statement
Namuna:
CREATEUNIQUEINDEX index_name
ON table_name ( column1, column2,...columnN);
SQL DROP INDEX Statement
Namuna:
ALTERTABLE table_name
DROPINDEX index_name;

SQL DESC Statement
Namuna:
DESC table_name;
SQL TRUNCATE TABLE Statement
Namuna:
TRUNCATETABLE table_name;
SQL ALTER TABLE Statement
Namuna:
ALTERTABLE table_name {ADD|DROP|MODIFY} column_name {dаtа_ype};
SQL ALTER TABLE Statement (Rename{Nomini o`zgartirish})
Namuna:
ALTERTABLE table_name RENAMETO new_table_name;

SQL INSERT INTO Statement
Namuna:
INSERTINTO table_name( column1, column2....columnN)
VALUES ( value1, value2....valueN);
SQL UPDATE Statement
Namuna:
UPDATE table_name
SET column1 = value1, column2 = value2....columnN=valueN
[ WHERE CONDITION ];
SQL DELETE Statement
Namuna:
DELETEFROM table_name
WHERE {CONDITION};
SQL CREATE dаtаBASE Statement
Namuna:
CREATEdаtаBASE dаtаbase_name;
SQL DROP dаtаBASE Statement
Namuna:
DROPdаtаBASE dаtаbase_name;
SQL USE Statement
Namuna:
USE dаtаbase_name;

SQL COMMIT Statement
Namuna:
COMMIT;

SQL ROLLBACK Statement
Namuna:
ROLLBACK;
Ma'lumotlar
Yaratilgan vaqt: 16 Aug 2018, 11:34
Muallif: @Arey (44)
Raxmat aytishgan: 0 kishi
Fikrlar: 0 ta
Ko'rilgan: 7 marta
Shikoyatim bor
Blog bilan bo'lishish
uzmasters.ru Onlayn 195 (0/195)
uzmasters.ru Forumga a'zo bo'lish
uzmasters.ru Forumdan qidirish
uzmasters.ru Bosh sahifa
Яндекс.Метрика UzMasterS.Ru