{"id":476664,"date":"2023-08-09T07:31:20","date_gmt":"2023-08-09T07:31:20","guid":{"rendered":""},"modified":"2023-09-05T11:13:11","modified_gmt":"2023-09-05T11:13:11","slug":"data-manipulation-language","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/ir\/wiki\/data-manipulation-language\/","title":{"rendered":"\u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627"},"content":{"rendered":"<p>\u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 (DML) \u0632\u06cc\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 SQL (\u0632\u0628\u0627\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647) \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc\u060c \u062f\u0631\u062c\u060c \u0627\u0635\u0644\u0627\u062d \u0648 \u062d\u0630\u0641 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0647\u062f\u0641 \u0627\u0635\u0644\u06cc DML \u0627\u0631\u0627\u0626\u0647 \u06cc\u06a9 \u0631\u0648\u0634 \u0645\u0646\u0639\u0637\u0641 \u0648 \u06a9\u0627\u0631\u0622\u0645\u062f \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u06cc\u0637 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a.<\/p>\n<h2>\u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0648 \u062a\u06a9\u0627\u0645\u0644 \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u062a\u0648\u0633\u0639\u0647 SQL \u062f\u0631 \u062f\u0647\u0647 1970 \u0633\u0631\u0686\u0634\u0645\u0647 \u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a. SQL \u062a\u0648\u0633\u0637 Raymond F. Boyce \u0648 Donald D. Chamberlin \u062f\u0631 IBM \u0627\u06cc\u062c\u0627\u062f \u0634\u062f. \u0622\u0646\u0647\u0627 \u0627\u0648\u0644\u06cc\u0646 \u0628\u0627\u0631 DML \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0628\u062e\u0634\u06cc \u0627\u0632 \u0632\u0628\u0627\u0646 SQL \u062f\u0631 \u0645\u0642\u0627\u0644\u0647 \u0627\u06cc \u062f\u0631 \u0633\u0627\u0644 1974 \u0628\u0647 \u0646\u0627\u0645 &quot;SEQUEL: A Structured English Query Language&quot; \u0645\u0639\u0631\u0641\u06cc \u06a9\u0631\u062f\u0646\u062f. \u0628\u0627 \u06af\u0630\u0634\u062a \u0632\u0645\u0627\u0646\u060c DML \u062a\u06a9\u0627\u0645\u0644 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647 \u0637\u0648\u0631 \u06af\u0633\u062a\u0631\u062f\u0647 \u0627\u06cc \u062f\u0631 \u0627\u0646\u0648\u0627\u0639 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 (DBMS) \u0628\u0647 \u06a9\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647 \u0628\u062e\u0634\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0627\u0632 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f\u0647\u0627\u06cc ANSI \u0648 ISO SQL \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<h2>\u0646\u06af\u0627\u0647\u06cc \u0639\u0645\u06cc\u0642 \u0628\u0647 \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u062f\u0633\u062a\u0648\u0631\u0627\u062a DML \u062f\u0631 \u0642\u0644\u0628 SQL \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u0646\u062f \u0648 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u06a9\u0646\u0646\u062f. \u0686\u0647\u0627\u0631 \u062f\u0633\u062a\u0648\u0631 \u0627\u0635\u0644\u06cc \u062f\u0631 DML \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ol>\n<li><strong>\u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f<\/strong>: \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0648 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u062c\u062f\u0648\u0644 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/li>\n<li><strong>\u062f\u0631\u062c \u06a9\u0646\u06cc\u062f<\/strong>: \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0631\u0627 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li><strong>\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc<\/strong>: \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li><strong>\u062d\u0630\u0641<\/strong>: \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ol>\n<p>\u062f\u0631\u06a9 \u0627\u06cc\u0646 \u0646\u06a9\u062a\u0647 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a\u060c \u0628\u0647 \u0648\u06cc\u0698\u0647 UPDATE \u0648 DELETE\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0628\u0647\u062a\u0631\u06cc\u0646 \u062a\u0645\u0631\u06cc\u0646 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0686\u0646\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a\u06cc \u0631\u0627 \u0628\u0627 \u0627\u062d\u062a\u06cc\u0627\u0637 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<h2>\u06a9\u0627\u0631\u0647\u0627\u06cc \u062f\u0631\u0648\u0646\u06cc \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u062f\u0631 \u06cc\u06a9 \u0633\u0637\u062d \u0627\u0633\u0627\u0633\u06cc\u060c DML \u0628\u0627 \u0627\u0631\u0633\u0627\u0644 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0628\u0647 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f. DBMS \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u062a\u0641\u0633\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0639\u0645\u0644\u06cc\u0627\u062a \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u06cc \u0631\u0627 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f \u0648 \u0647\u0631 \u062f\u0627\u062f\u0647 \u062f\u0631\u062e\u0648\u0627\u0633\u062a\u06cc \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f. DBMS \u062a\u0645\u0627\u0645 \u067e\u06cc\u0686\u06cc\u062f\u06af\u06cc \u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0648 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0646\u0633\u0628\u062a\u0627\u064b \u0633\u0627\u062f\u0647 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f.<\/p>\n<p>\u0627\u0632 \u0646\u0638\u0631 \u0627\u062c\u0631\u0627\u060c \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 DML \u0631\u0627 \u062f\u0631 \u062f\u0648 \u0645\u0631\u062d\u0644\u0647 \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<ol>\n<li><strong>\u0632\u0645\u0627\u0646 \u06a9\u0627\u0645\u067e\u0627\u06cc\u0644<\/strong>: \u0646\u062d\u0648 \u062f\u0633\u062a\u0648\u0631 SQL \u0628\u0631\u0631\u0633\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li><strong>\u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627<\/strong>: \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0633\u062a\u0648\u0631 SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<\/ol>\n<h2>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u0628\u0631\u062e\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u0647\u0645 DML \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ul>\n<li><strong>\u0633\u0627\u062f\u06af\u06cc<\/strong>: \u062f\u0633\u062a\u0648\u0631\u0627\u062a DML \u0633\u0627\u062f\u0647 \u0648 \u0642\u0627\u0628\u0644 \u062f\u0631\u06a9 \u0647\u0633\u062a\u0646\u062f.<\/li>\n<li><strong>\u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc<\/strong>: DML \u0627\u0645\u06a9\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0647\u0631 \u062f\u0648 \u0633\u0637\u062d \u0631\u06a9\u0648\u0631\u062f \u0648 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<li><strong>\u0645\u062f\u06cc\u0631\u06cc\u062a \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u062f\u0627\u062f\u0647 \u0647\u0627<\/strong>: DML \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u062b\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0646\u062f.<\/li>\n<li><strong>\u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/strong>: DML \u06cc\u06a9\u067e\u0627\u0631\u0686\u06af\u06cc \u0648 \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<\/ul>\n<h2>\u0627\u0646\u0648\u0627\u0639 \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u062f\u0648 \u0646\u0648\u0639 DML \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<\/p>\n<ol>\n<li><strong>DML \u0631\u0648\u06cc\u0647 \u0627\u06cc<\/strong>: \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u062f \u06a9\u0647 \u0645\u0634\u062e\u0635 \u06a9\u0646\u062f \u0686\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a \u0648 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0622\u0646 \u0647\u0627 \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f.<\/li>\n<li><strong>DML \u063a\u06cc\u0631 \u0631\u0648\u06cc\u0647 \u0627\u06cc<\/strong>: \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0645\u0644\u0632\u0645 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u0628\u062f\u0648\u0646 \u062a\u0639\u06cc\u06cc\u0646 \u0646\u062d\u0648\u0647 \u062f\u0631\u06cc\u0627\u0641\u062a \u0622\u0646\u060c \u0645\u0634\u062e\u0635 \u06a9\u0646\u062f \u0686\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a.<\/li>\n<\/ol>\n<p>\u062c\u062f\u0648\u0644 \u0632\u06cc\u0631 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0627\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0648 \u0646\u0648\u0639 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0648\u06cc\u0698\u06af\u06cc<\/th>\n<th>DML \u0631\u0648\u06cc\u0647 \u0627\u06cc<\/th>\n<th>DML \u063a\u06cc\u0631 \u0631\u0648\u06cc\u0647 \u0627\u06cc<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0631\u0627\u062d\u062a\u06cc \u062f\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647<\/td>\n<td>\u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0627\u0646\u0634 \u062f\u0631 \u0645\u0648\u0631\u062f \u0646\u062d\u0648\u0647 \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0627\u0631\u062f<\/td>\n<td>\u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0622\u0633\u0627\u0646 \u062a\u0631 \u0627\u0633\u062a\u060c \u0641\u0642\u0637 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0627\u0646\u0633\u062a\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f<\/td>\n<\/tr>\n<tr>\n<td>\u0628\u0647\u0631\u0647 \u0648\u0631\u06cc<\/td>\n<td>\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u0628\u0627\u0634\u062f \u0632\u06cc\u0631\u0627 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0637\u0648\u0631 \u062e\u0627\u0635 \u0633\u06cc\u0633\u062a\u0645 \u0631\u0627 \u0647\u062f\u0627\u06cc\u062a \u06a9\u0646\u062f<\/td>\n<td>\u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u06a9\u0627\u0631\u0627\u06cc\u06cc \u06a9\u0645\u062a\u0631\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u0632\u06cc\u0631\u0627 \u0633\u06cc\u0633\u062a\u0645 \u0628\u0627\u06cc\u062f \u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0627\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u062f<\/td>\n<\/tr>\n<tr>\n<td>\u0645\u062b\u0627\u0644 \u0647\u0627<\/td>\n<td>SQL \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u0627 JOIN\u060c WHERE \u0648 \u0633\u0627\u06cc\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0645\u0634\u0627\u0628\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f<\/td>\n<td>SQL \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u0648\u0644\u06cc\u0647 SELECT \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u0627\u0633\u062a\u0641\u0627\u062f\u0647\u060c \u0645\u0633\u0627\u0626\u0644 \u0648 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627 \u062f\u0631 \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>DML \u0628\u0647 \u0637\u0648\u0631 \u06af\u0633\u062a\u0631\u062f\u0647 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u0632 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0633\u0627\u062f\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0631\u0627\u06cc \u06af\u0632\u0627\u0631\u0634 \u0647\u0627 \u062a\u0627 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0646\u0627\u062f\u0631\u0633\u062a \u0627\u0632 DML \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0646\u062c\u0631 \u0628\u0647 \u062e\u0631\u0627\u0628 \u0634\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0627\u0632 \u062f\u0633\u062a \u062f\u0627\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0645\u0634\u06a9\u0644\u0627\u062a \u0639\u0645\u0644\u06a9\u0631\u062f \u0634\u0648\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u06a9\u0627\u0647\u0634 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644\u0627\u062a\u060c \u0628\u0631\u062e\u06cc \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06cc\u0648\u0647 \u0647\u0627 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ul>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0631\u0627\u06a9\u0646\u0634 \u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u06cc\u06a9\u067e\u0627\u0631\u0686\u06af\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627.<\/li>\n<li>\u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a DELETE \u0648 UPDATE \u0628\u0631\u0627\u06cc \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u0627\u0632 \u062f\u0633\u062a \u062f\u0627\u062f\u0646 \u062a\u0635\u0627\u062f\u0641\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627.<\/li>\n<li>\u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u06af\u06cc\u0631\u06cc \u0645\u0646\u0638\u0645 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/li>\n<li>\u0627\u0639\u0645\u0627\u0644 \u0645\u062c\u0648\u0632\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc \u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0646 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0633\u062a\u0648\u0631\u0627\u062a DML \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u0646\u062f.<\/li>\n<\/ul>\n<h2>\u0645\u0642\u0627\u06cc\u0633\u0647 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647<\/h2>\n<p>\u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 SQL \u0648 \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 DML \u0628\u0647 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u062f\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0646\u062f\u060c \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0646\u06cc\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f. \u062f\u0648 \u0645\u062b\u0627\u0644 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647 XQuery \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 XML \u0648 SPARQL \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 RDF \u0647\u0633\u062a\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u0632\u0628\u0627\u0646 \u0647\u0627 \u062a\u0645\u0631\u06a9\u0632 \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u0646\u0633\u0628\u062a \u0628\u0647 SQL \u0648 DML \u062f\u0627\u0631\u0646\u062f\u060c \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 XQuery \u0628\u0631 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0645\u0627\u0646\u0646\u062f \u0633\u0646\u062f \u0648 SPARQL \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0648\u0628 \u0645\u0639\u0646\u0627\u06cc\u06cc \u062a\u0645\u0631\u06a9\u0632 \u062f\u0627\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0622\u0646\u0647\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631\u0627\u062a SELECT\u060c INSERT\u060c UPDATE \u0648 DELETE \u0645\u0648\u062c\u0648\u062f \u062f\u0631 DML \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f.<\/p>\n<h2>\u0686\u0634\u0645 \u0627\u0646\u062f\u0627\u0632 \u0622\u06cc\u0646\u062f\u0647 \u0628\u0631\u0627\u06cc \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0647\u0645\u0686\u0646\u0627\u0646 \u0633\u0646\u06af \u0628\u0646\u0627\u06cc \u0641\u0646\u0627\u0648\u0631\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0647\u0633\u062a\u0646\u062f\u060c \u0627\u0647\u0645\u06cc\u062a DML \u0647\u0645\u0686\u0646\u0627\u0646 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062a\u0648\u0633\u0639\u0647\u200c\u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 NoSQL \u0648 \u067e\u0644\u062a\u0641\u0631\u0645\u200c\u0647\u0627\u06cc Big Data \u0686\u0627\u0644\u0634\u200c\u0647\u0627 \u0648 \u0641\u0631\u0635\u062a\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u06cc \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u0646\u062f. \u062a\u06a9\u0627\u0645\u0644 DML\u060c \u06cc\u0627 \u062a\u0648\u0633\u0639\u0647 \u0632\u0628\u0627\u0646\u200c\u0647\u0627\u06cc \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u0627\u06cc\u0646 \u0686\u0627\u0644\u0634\u200c\u0647\u0627\u060c \u0641\u0636\u0627\u06cc \u062c\u0630\u0627\u0628\u06cc \u0628\u0631\u0627\u06cc \u062a\u0645\u0627\u0634\u0627 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n<h2>\u062a\u0642\u0627\u0637\u0639 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u0648 \u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/h2>\n<p>\u06cc\u06a9 \u0633\u0631\u0648\u0631 \u067e\u0631\u0648\u06a9\u0633\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0648\u0627\u0633\u0637\u0647 \u0628\u06cc\u0646 \u0645\u0634\u062a\u0631\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0645\u0646\u0627\u0628\u0639 \u0627\u0632 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0633\u062a \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f. \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u067e\u0631\u0648\u06a9\u0633\u06cc \u0628\u0647 \u0637\u0648\u0631 \u0630\u0627\u062a\u06cc \u0628\u0627 DML \u062a\u0639\u0627\u0645\u0644 \u0646\u062f\u0627\u0631\u0646\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062d\u0641\u0638 \u0627\u0645\u0646\u06cc\u062a \u0648 \u0646\u0627\u0634\u0646\u0627\u0633 \u0628\u0648\u062f\u0646 \u0646\u0642\u0634 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f.<\/p>\n<p>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u067e\u0631\u0648\u06a9\u0633\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u0645\u062a\u0639\u0627\u062f\u0644 \u06a9\u0631\u062f\u0646 \u0628\u0627\u0631 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc DML \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u06cc\u062f. \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0628\u0627 \u0645\u0633\u06cc\u0631\u06cc\u0627\u0628\u06cc \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u067e\u0631\u0627\u06a9\u0633\u06cc\u060c \u06cc\u06a9 \u0644\u0627\u06cc\u0647 \u0646\u0627\u0634\u0646\u0627\u0633 \u0648 \u0627\u0645\u0646\u06cc\u062a \u0627\u0636\u0627\u0641\u06cc \u0628\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 \u062e\u0637\u0631 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u0631\u0628 \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<h2>\u0644\u06cc\u0646\u06a9 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/default.asp\" target=\"_new\" rel=\"noopener nofollow\">\u0622\u0645\u0648\u0632\u0634 SQL \u062a\u0648\u0633\u0637 W3Schools<\/a><\/li>\n<li><a href=\"https:\/\/www.dataversity.net\/sql-foundation-data-manipulation\/\" target=\"_new\" rel=\"noopener nofollow\">SQL: \u0628\u0646\u06cc\u0627\u062f\u06cc \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14200\/statements_10002.htm\" target=\"_new\" rel=\"noopener nofollow\">\u0632\u0628\u0627\u0646 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0648\u0633\u0637 \u0627\u0648\u0631\u0627\u06a9\u0644<\/a><\/li>\n<\/ul>\n<p>\u0628\u0627 \u062f\u0631\u06a9 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d \u0627\u0632 DML\u060c \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u06cc\u0637 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc\u0627\u0641\u062a\u0647 \u062a\u0639\u0627\u0645\u0644 \u06a9\u0631\u062f \u0648 \u0622\u0646 \u0631\u0627 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u06a9\u0631\u062f\u060c \u06a9\u0647 \u06cc\u06a9 \u0645\u0647\u0627\u0631\u062a \u062d\u06cc\u0627\u062a\u06cc \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u0631\u0648\u0632\u0627\u0641\u0632\u0648\u0646 \u062f\u0627\u062f\u0647 \u0645\u062d\u0648\u0631 \u0645\u0627 \u0627\u0633\u062a.<\/p>","protected":false},"featured_media":476665,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-476664","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Data Manipulation Language: A Comprehensive Guide<\/mark>","faq_items":[{"question":"What is Data Manipulation Language?","answer":"<p>Data Manipulation Language (DML) is a subset of SQL (Structured Query Language) used to retrieve, insert, modify, and delete data in a database. It is primarily designed to facilitate efficient and flexible manipulation of data within a structured database environment.<\/p>"},{"question":"What is the history of Data Manipulation Language?","answer":"<p>DML originated from the development of SQL in the 1970s by Raymond F. Boyce and Donald D. Chamberlin at IBM. They first introduced DML as part of the SQL language in a 1974 paper called \"SEQUEL: A Structured English Query Language\". Since then, DML has evolved and has been widely adopted in various database management systems (DBMS), becoming a standard part of ANSI and ISO SQL standards.<\/p>"},{"question":"What are the key features of Data Manipulation Language?","answer":"<p>Key features of DML include simplicity, flexibility, powerful data handling, and data consistency. DML commands are simple and easy to understand, allow data manipulation at both record and set levels, can efficiently handle a large volume of data, and ensure the integrity and consistency of the data within the database.<\/p>"},{"question":"What are the types of Data Manipulation Language?","answer":"<p>There are two types of DML: Procedural and Non-Procedural. Procedural DML requires a user to specify what data is needed and how to get it. In contrast, Non-Procedural DML requires a user to specify what data is needed without dictating how to get it.<\/p>"},{"question":"What problems can arise from using Data Manipulation Language, and how can they be solved?","answer":"<p>Improper use of DML can result in data corruption, data loss, and performance issues. These problems can be mitigated by using transactions to ensure data integrity, limiting the use of the DELETE and UPDATE commands to prevent accidental data loss, regularly backing up the database, and applying appropriate user permissions to limit who can execute DML commands.<\/p>"},{"question":"How are proxy servers associated with Data Manipulation Language?","answer":"<p>While proxy servers don't inherently interact with DML, they can be configured to manage database requests, thereby maintaining security and anonymity. For instance, a proxy server can balance the load of DML requests across multiple databases, improving performance. Additionally, by routing database requests through a proxy server, an extra layer of security and anonymity is added to the data manipulation process.<\/p>"},{"question":"What are the future prospects for Data Manipulation Language?","answer":"<p>As databases continue to be central to information technology, DML's relevance is expected to remain significant. With the advent of NoSQL databases and Big Data platforms, there are new challenges and opportunities for DML. The evolution of DML to handle these challenges, or the development of new data manipulation languages, is an area to watch in the future.<\/p>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki\/476664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/wiki\/476664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/media\/476665"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/ir\/wp-json\/wp\/v2\/media?parent=476664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}