- \n
- \u0422\u0430\u04a3\u0434\u0430\u0443 (SELECT)<\/li>\n\n\n\n
- \u0415\u043d\u0433\u0456\u0437\u0443 (INSERT)<\/li>\n\n\n\n
- \u0416\u0430\u04a3\u0430\u0440\u0442\u0443 (UPDATE)<\/li>\n\n\n\n
- \u0416\u043e\u044e (DELETE)<\/li>\n\n\n\n
- \u0414\u0435\u0440\u0435\u043a\u049b\u043e\u0440 \u043c\u0435\u043d \u043a\u0435\u0441\u0442\u0435 \u049b\u04b1\u0440\u0443 (CREATE)<\/li>\n<\/ul>\n\n\n\n
SQL \u043a\u04e9\u0431\u0456\u043d\u0435\u0441\u0435 MySQL<\/strong>, PostgreSQL<\/strong>, Oracle<\/strong>, SQLite<\/strong>, MS SQL Server<\/strong> \u0441\u0438\u044f\u049b\u0442\u044b \u0434\u0435\u0440\u0435\u043a\u049b\u043e\u0440 \u0431\u0430\u0441\u049b\u0430\u0440\u0443 \u0436\u04af\u0439\u0435\u043b\u0435\u0440\u0456\u043d\u0434\u0435 \u049b\u043e\u043b\u0434\u0430\u043d\u044b\u043b\u0430\u0434\u044b.<\/p>\n\n\n\n
SQL \u0442\u0456\u043b\u0456\u043d\u0456\u04a3 \u043d\u0435\u0433\u0456\u0437\u0433\u0456 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043b\u0430\u0440\u044b<\/h2>\n\n\n\n
\u041a\u043e\u043c\u0430\u043d\u0434\u0430<\/th> \u0421\u0438\u043f\u0430\u0442\u0442\u0430\u043c\u0430\u0441\u044b<\/th><\/tr><\/thead> SELECT<\/code><\/td>\u041a\u0435\u0441\u0442\u0435\u0434\u0435\u043d \u0434\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u0434\u0456 \u0442\u0430\u04a3\u0434\u0430\u0443<\/td><\/tr> INSERT<\/code><\/td>\u0416\u0430\u04a3\u0430 \u0436\u043e\u043b (\u0434\u0435\u0440\u0435\u043a) \u049b\u043e\u0441\u0443<\/td><\/tr> UPDATE<\/code><\/td>\u0411\u0430\u0440 \u0434\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u0434\u0456 \u0436\u0430\u04a3\u0430\u0440\u0442\u0443<\/td><\/tr> DELETE<\/code><\/td>\u0414\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u0434\u0456 \u0436\u043e\u044e<\/td><\/tr> CREATE<\/code><\/td>\u0416\u0430\u04a3\u0430 \u043a\u0435\u0441\u0442\u0435 \u043d\u0435\u043c\u0435\u0441\u0435 \u0431\u0430\u0437\u0430 \u049b\u04b1\u0440\u0443<\/td><\/tr> DROP<\/code><\/td>\u041a\u0435\u0441\u0442\u0435\u043d\u0456 \u043d\u0435\u043c\u0435\u0441\u0435 \u0431\u0430\u0437\u0430\u043d\u044b \u0436\u043e\u044e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n\u0425\u043e\u0441\u0442\u0438\u043d\u0433 \u043f\u0430\u043d\u0435\u043b\u0456\u043d\u0434\u0435\u0433\u0456 — \u0411\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 — phpMyAdmin \u049b\u043e\u0441\u044b\u043c\u0448\u0430\u0441\u044b\u043d \u0430\u0448\u0443<\/p>\n\n\n\n
![\"\"](\"https:\/\/edu.govs.kz\/openedu\/wp-content\/uploads\/2025\/05\/image-8-1024x212.png\")
<\/figure>\n\n\n\nSQL \u0432\u043a\u043b\u0430\u0434\u043a\u0430\u0441\u044b \u0430\u0440\u049b\u044b\u043b\u044b \u043e\u0441\u044b \u0431\u0430\u0437\u0430\u0493\u0430 \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u043b\u0430\u0440 \u0436\u0430\u0437\u0430 \u0430\u043b\u0430\u043c\u044b\u0437<\/p>\n\n\n\n
![\"\"](\"https:\/\/edu.govs.kz\/openedu\/wp-content\/uploads\/2025\/05\/image-9-1024x393.png\")
<\/figure>\n\n\n\n\u041a\u0435\u0441\u0442\u0435 \u049b\u04b1\u0440\u0443 (CREATE TABLE)<\/h2>\n\n\n\n
CREATE TABLE student (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100),
age INT,
city VARCHAR(50)
);
<\/code><\/pre>\n\n\n\n\n
\u0411\u04b1\u043b \u043a\u043e\u043c\u0430\u043d\u0434\u0430
student<\/code> \u0430\u0442\u0442\u044b \u043a\u0435\u0441\u0442\u0435 \u0436\u0430\u0441\u0430\u0439\u0434\u044b. \u04d8\u0440 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u0442\u0456\u04a3 id, \u0430\u0442\u044b, \u0436\u0430\u0441\u044b, \u0436\u04d9\u043d\u0435 \u0442\u04b1\u0440\u0430\u0442\u044b\u043d \u049b\u0430\u043b\u0430\u0441\u044b \u0431\u043e\u043b\u0430\u0434\u044b.<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\n\u0414\u0435\u0440\u0435\u043a \u049b\u043e\u0441\u0443 (INSERT INTO)<\/h2>\n\n\n\n
INSERT INTO student (name, age, city)
VALUES ('\u0410\u0439\u0434\u0430\u043d\u0430', 20, '\u0410\u043b\u043c\u0430\u0442\u044b');
<\/code><\/pre>\n\n\n\n
\n\n\n\n\u0414\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u0434\u0456 \u0442\u0430\u04a3\u0434\u0430\u0443 (SELECT)<\/h2>\n\n\n\n
SELECT * FROM student;
<\/code><\/pre>\n\n\n\n\n
\u0411\u0430\u0440\u043b\u044b\u049b \u0431\u0430\u0493\u0430\u043d\u0434\u0430\u0440\u0434\u044b \u0448\u044b\u0493\u0430\u0440\u0430\u0434\u044b.<\/p>\n<\/blockquote>\n\n\n\n
SELECT name, city FROM student WHERE age > 18;
<\/code><\/pre>\n\n\n\n\n
18 \u0436\u0430\u0441\u0442\u0430\u043d \u04af\u043b\u043a\u0435\u043d \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u0442\u0435\u0440\u0434\u0456\u04a3 \u0430\u0442\u044b \u043c\u0435\u043d \u049b\u0430\u043b\u0430\u0441\u044b.<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\n\u0416\u0430\u04a3\u0430\u0440\u0442\u0443 (UPDATE)<\/h2>\n\n\n\n
UPDATE student
SET city = '\u0410\u0441\u0442\u0430\u043d\u0430'
WHERE name = '\u0410\u0439\u0434\u0430\u043d\u0430';
<\/code><\/pre>\n\n\n\n
\n\n\n\n\u0416\u043e\u044e (DELETE)<\/h2>\n\n\n\n
DELETE FROM student WHERE age < 18;
<\/code><\/pre>\n\n\n\n
\n\n\n\n\u049a\u043e\u0441\u044b\u043c\u0448\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u043b\u0430\u0440<\/h2>\n\n\n\n
\u041a\u043e\u043c\u0430\u043d\u0434\u0430<\/th> \u041c\u044b\u0441\u0430\u043b<\/th><\/tr><\/thead> ORDER BY<\/code><\/td>SELECT * FROM student ORDER BY age DESC;<\/code><\/td><\/tr>LIMIT<\/code><\/td>SELECT * FROM student LIMIT 5;<\/code><\/td><\/tr>LIKE<\/code><\/td>WHERE name LIKE '\u0410%'<\/code><\/td><\/tr>BETWEEN<\/code><\/td>WHERE age BETWEEN 18 AND 25<\/code><\/td><\/tr>IN<\/code><\/td>WHERE city IN ('\u0410\u043b\u043c\u0430\u0442\u044b', '\u0410\u0441\u0442\u0430\u043d\u0430')<\/code><\/td><\/tr>AS<\/code><\/td>SELECT name AS \"\u0410\u0442\u044b\" FROM student;<\/code><\/td><\/tr>COUNT()<\/code><\/td>SELECT COUNT(*) FROM student;<\/code><\/td><\/tr>GROUP BY<\/code><\/td>GROUP BY city<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nSQL \u043c\u0435\u043d PHP \u0431\u0430\u0439\u043b\u0430\u043d\u044b\u0441\u044b<\/h1>\n\n\n\n
PHP<\/strong> \u2013 \u0441\u0435\u0440\u0432\u0435\u0440\u043b\u0456\u043a \u0442\u0456\u043b.
SQL<\/strong> \u2013 \u043c\u04d9\u043b\u0456\u043c\u0435\u0442\u0442\u0435\u0440 \u0431\u0430\u0437\u0430\u0441\u044b\u043c\u0435\u043d \u0436\u04b1\u043c\u044b\u0441 \u0456\u0441\u0442\u0435\u0439\u0442\u0456\u043d \u0442\u0456\u043b.
PHP \u0430\u0440\u049b\u044b\u043b\u044b \u0431\u0456\u0437 SQL \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u043b\u0430\u0440\u044b\u043d \u043e\u0440\u044b\u043d\u0434\u0430\u0439\u043c\u044b\u0437<\/strong>: \u0434\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u0434\u0456 \u049b\u043e\u0441\u0430\u043c\u044b\u0437<\/strong>, \u0448\u044b\u049b\u0430\u0440\u0430\u043c\u044b\u0437<\/strong>, \u04e9\u0448\u0456\u0440\u0435\u043c\u0456\u0437<\/strong>, \u0436\u0430\u04a3\u0430\u0440\u0442\u0430\u043c\u044b\u0437<\/strong>.<\/p>\n\n\n\n
\n\n\n\n1-\u041c\u044b\u0441\u0430\u043b: \u041a\u0435\u0441\u0442\u0435\u0434\u0435\u043d \u043c\u04d9\u043b\u0456\u043c\u0435\u0442 \u0448\u044b\u0493\u0430\u0440\u0443 (
SELECT<\/code>)<\/h2>\n\n\n\nMySQL-\u0434\u0435 \u043e\u0441\u044b\u043d\u0434\u0430\u0439 \u0431\u0430\u0437\u0430 \u0431\u0430\u0440 \u0434\u0435\u043f \u0435\u043b\u0435\u0441\u0442\u0435\u0442\u0435\u0439\u0456\u043a:<\/h3>\n\n\n\n
\u041a\u0435\u0441\u0442\u0435 \u0430\u0442\u044b:<\/strong>
student<\/code><\/p>\n\n\n\nid<\/th> name<\/th> age<\/th> city<\/th><\/tr><\/thead> 1<\/td> \u0410\u0439\u0433\u04af\u043b<\/td> 19<\/td> \u0410\u043b\u043c\u0430\u0442\u044b<\/td><\/tr> 2<\/td> \u0411\u0435\u0440\u0456\u043a<\/td> 21<\/td> \u0410\u0441\u0442\u0430\u043d\u0430<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\nPHP-\u043a\u043e\u0434 (\u043c\u04d9\u043b\u0456\u043c\u0435\u0442\u0442\u0435\u0440\u0434\u0456 \u0448\u044b\u0493\u0430\u0440\u0443)<\/h3>\n\n\n\n
<?php
\/\/ 1. \u0414\u0435\u0440\u0435\u043a\u049b\u043e\u0440\u043c\u0435\u043d \u049b\u043e\u0441\u044b\u043b\u0443
$conn = mysqli_connect(\"localhost\", \"root\", \"\", \"my_database\");
\/\/ 2. SQL \u0441\u04b1\u0440\u0430\u043d\u044b\u0441 \u0436\u0430\u0437\u0443
$sql = \"SELECT * FROM student\";
\/\/ 3. \u041d\u04d9\u0442\u0438\u0436\u0435\u043d\u0456 \u043e\u0440\u044b\u043d\u0434\u0430\u0443
$result = mysqli_query($conn, $sql);
\/\/ 4. \u041c\u04d9\u043b\u0456\u043c\u0435\u0442\u0442\u0435\u0440\u0434\u0456 \u0448\u044b\u0493\u0430\u0440\u0443
while ($row = mysqli_fetch_assoc($result)) {
echo \"\u0410\u0442\u044b: \" . $row['name'] . \" | \u0416\u0430\u0441\u044b: \" . $row['age'] . \" | \u049a\u0430\u043b\u0430\u0441\u044b: \" . $row['city'] . \"<br>\";
}
\/\/ 5. \u049a\u043e\u0441\u044b\u043b\u044b\u043c\u0434\u044b \u0436\u0430\u0431\u0443
mysqli_close($conn);
?>
<\/code><\/pre>\n\n\n\n\u0411\u04b1\u043b \u043a\u043e\u0434 \u0434\u0435\u0440\u0435\u043a\u049b\u043e\u0440\u0434\u0430\u043d \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u0442\u0435\u0440\u0434\u0456 \u0448\u044b\u0493\u0430\u0440\u0430\u0434\u044b.<\/p>\n\n\n\n
\n\n\n\n2-\u041c\u044b\u0441\u0430\u043b: \u0416\u0430\u04a3\u0430 \u043c\u04d9\u043b\u0456\u043c\u0435\u0442 \u049b\u043e\u0441\u0443 (
INSERT INTO<\/code>)<\/h2>\n\n\n\n<?php
$conn = mysqli_connect(\"localhost\", \"root\", \"\", \"my_database\");
$name = \"\u0421\u0430\u044f\u0436\u0430\u043d\";
$age = 18;
$city = \"\u0428\u044b\u043c\u043a\u0435\u043d\u0442\";
$sql = \"INSERT INTO student (name, age, city) VALUES ('$name', $age, '$city')\";
mysqli_query($conn, $sql);
echo \"\u0416\u0430\u04a3\u0430 \u0441\u0442\u0443\u0434\u0435\u043d\u0442 \u049b\u043e\u0441\u044b\u043b\u0434\u044b!\";
mysqli_close($conn);
?>
<\/code><\/pre>\n\n\n\n\u0411\u04b1\u043b \u043a\u043e\u0434 \u0436\u0430\u04a3\u0430 \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u0442\u0456 \u0431\u0430\u0437\u0430\u0493\u0430 \u049b\u043e\u0441\u0430\u0434\u044b.<\/p>\n\n\n\n
\n\n\n\n\u041c\u04d9\u043b\u0456\u043c\u0435\u0442\u0442\u0456 \u0436\u0430\u04a3\u0430\u0440\u0442\u0443 (
UPDATE<\/code>)<\/h2>\n\n\n\n<?php
$conn = mysqli_connect(\"localhost\", \"root\", \"\", \"my_database\");
$sql = \"UPDATE student SET city = '\u0422\u0430\u0440\u0430\u0437' WHERE name = '\u0421\u0430\u044f\u0436\u0430\u043d'\";
mysqli_query($conn, $sql);
echo \"\u041c\u04d9\u043b\u0456\u043c\u0435\u0442 \u0436\u0430\u04a3\u0430\u0440\u0442\u044b\u043b\u0434\u044b!\";
mysqli_close($conn);
?>
<\/code><\/pre>\n\n\n\n
\n\n\n\n4-\u041c\u044b\u0441\u0430\u043b: \u041c\u04d9\u043b\u0456\u043c\u0435\u0442\u0442\u0456 \u04e9\u0448\u0456\u0440\u0443 (
DELETE<\/code>)<\/h2>\n\n\n\n<?php
$conn = mysqli_connect(\"localhost\", \"root\", \"\", \"my_database\");
$sql = \"DELETE FROM student WHERE name = '\u0411\u0435\u0440\u0456\u043a'\";
mysqli_query($conn, $sql);
echo \"\u0421\u0442\u0443\u0434\u0435\u043d\u0442 \u04e9\u0448\u0456\u0440\u0456\u043b\u0434\u0456!\";
mysqli_close($conn);
?>
<\/code><\/pre>\n\n\n\n
\n\n\n\n\u049a\u044b\u0441\u049b\u0430\u0448\u0430 \u0442\u04af\u0441\u0456\u043d\u0456\u043a:<\/h2>\n\n\n\n
PHP \u0431\u04e9\u043b\u0456\u0433\u0456<\/th> \u041c\u0430\u049b\u0441\u0430\u0442\u044b<\/th><\/tr><\/thead> mysqli_connect()<\/code><\/td>\u0411\u0430\u0437\u0430\u0493\u0430 \u049b\u043e\u0441\u044b\u043b\u0443<\/td><\/tr> mysqli_query()<\/code><\/td>SQL \u0441\u04b1\u0440\u0430\u043d\u044b\u0441\u0442\u044b \u043e\u0440\u044b\u043d\u0434\u0430\u0443<\/td><\/tr> mysqli_fetch_assoc()<\/code><\/td>\u041d\u04d9\u0442\u0438\u0436\u0435\u043d\u0456 \u0448\u044b\u0493\u0430\u0440\u0443 (\u0431\u0456\u0440-\u0431\u0456\u0440\u0434\u0435\u043d)<\/td><\/tr> mysqli_close()<\/code><\/td>\u049a\u043e\u0441\u044b\u043b\u044b\u043c\u0434\u044b \u0436\u0430\u0431\u0443<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n <\/p>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0411\u0456\u0437 \u043a\u0435\u0437 \u043a\u0435\u043b\u0433\u0435\u043d CMS \u043f\u0435\u043d \u0436\u04b1\u043c\u044b\u0441 \u0436\u0430\u0441\u0430\u0493\u0430\u043d\u0434\u0430 \u0436\u04af\u0439\u0435\u043d\u0456\u04a3 \u0444\u0430\u0439\u043b\u0434\u0430\u0440\u044b zip \u0444\u0430\u0439\u043b \u0430\u0440\u049b\u044b\u043b\u044b \u0431\u0435\u0440\u0456\u043b\u0441\u0435, \u0414\u0435\u0440\u0435\u043a\u0442\u0435\u0440 \u049b\u043e\u0440\u044b .SQL \u043a\u0435\u04a3\u0435\u0439\u0442\u0456\u043b\u0456\u043c\u0456\u043d\u0434\u0435\u0433\u0456 \u0444\u0430\u0439\u043b \u0430\u0440\u049b\u044b\u043b\u044b \u0431\u0435\u0440\u0456\u043b\u0435\u0434\u0456 \u041c\u044b\u0441\u0430\u043b\u044b: \u041c\u0435\u043d\u0456\u04a3\u0441\u0430\u0439\u0442\u044b\u043c.zip \u0431\u043e\u043b\u0441\u0430, \u0414\u0435\u0440\u0435\u043a\u0442\u0435\u0440 \u049b\u043e\u0440\u044b: \u0414\u0435\u0440\u0435\u043a\u0442\u0435\u0440\u049b\u043e\u0440\u044b.sql \u0444\u0430\u0439\u043b\u044b \u0430\u0440\u049b\u044b\u043b\u044b \u0441\u0430\u049b\u0442\u0430\u043b\u0430\u0434\u044b. \u0411\u04b1\u043b \u0444\u0430\u0439\u043b \u0456\u0448\u0456\u043d\u0434\u0435 \u0440\u0435\u0442\u0456\u043c\u0435\u043d \u0441\u0430\u049b\u0442\u0430\u043b\u0493\u0430\u043d \u0436\u04af\u0439\u0435\u0433\u0435