{"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\/ar\/wiki\/data-manipulation-language\/","title":{"rendered":"\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a"},"content":{"rendered":"<p>\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (DML) \u0647\u064a \u0645\u062c\u0645\u0648\u0639\u0629 \u0641\u0631\u0639\u064a\u0629 \u0645\u0646 SQL (\u0644\u063a\u0629 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u0647\u064a\u0643\u0644\u064a\u0629) \u0627\u0644\u062a\u064a \u064a\u062a\u0645 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u0644\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0625\u062f\u0631\u0627\u062c\u0647\u0627 \u0648\u062a\u0639\u062f\u064a\u0644\u0647\u0627 \u0648\u062d\u0630\u0641\u0647\u0627 \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u0627\u0644\u063a\u0631\u0636 \u0627\u0644\u0623\u0633\u0627\u0633\u064a \u0645\u0646 DML \u0647\u0648 \u062a\u0648\u0641\u064a\u0631 \u0637\u0631\u064a\u0642\u0629 \u0645\u0631\u0646\u0629 \u0648\u0641\u0639\u0627\u0644\u0629 \u0644\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062f\u0627\u062e\u0644 \u0628\u064a\u0626\u0629 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646\u0638\u0645\u0629.<\/p>\n<h2>\u062a\u0627\u0631\u064a\u062e \u0648\u062a\u0637\u0648\u0631 \u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0646\u0634\u0623\u062a \u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u062a\u0637\u0648\u064a\u0631 SQL \u062e\u0644\u0627\u0644 \u0627\u0644\u0633\u0628\u0639\u064a\u0646\u064a\u0627\u062a. \u062a\u0645 \u0625\u0646\u0634\u0627\u0621 SQL \u0628\u0648\u0627\u0633\u0637\u0629 Raymond F. Boyce \u0648Donald D. Chamberlin \u0641\u064a IBM. \u0644\u0642\u062f \u0642\u062f\u0645\u0648\u0627 DML \u0644\u0623\u0648\u0644 \u0645\u0631\u0629 \u0643\u062c\u0632\u0621 \u0645\u0646 \u0644\u063a\u0629 SQL \u0641\u064a \u0648\u0631\u0642\u0629 \u0628\u062d\u062b\u064a\u0629 \u0639\u0627\u0645 1974 \u0628\u0639\u0646\u0648\u0627\u0646 &quot;SEQUEL: \u0644\u063a\u0629 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0625\u0646\u062c\u0644\u064a\u0632\u064a\u0629 \u0645\u0646\u0638\u0645\u0629&quot;. \u0645\u0639 \u0645\u0631\u0648\u0631 \u0627\u0644\u0648\u0642\u062a\u060c \u062a\u0637\u0648\u0631\u062a DML \u0648\u062a\u0645 \u0627\u0639\u062a\u0645\u0627\u062f\u0647\u0627 \u0639\u0644\u0649 \u0646\u0637\u0627\u0642 \u0648\u0627\u0633\u0639 \u0641\u064a \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646 \u0623\u0646\u0638\u0645\u0629 \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (DBMS)\u060c \u0644\u062a\u0635\u0628\u062d \u062c\u0632\u0621\u064b\u0627 \u0642\u064a\u0627\u0633\u064a\u064b\u0627 \u0645\u0646 \u0645\u0639\u0627\u064a\u064a\u0631 ANSI \u0648ISO SQL.<\/p>\n<h2>\u0646\u0638\u0631\u0629 \u0645\u062a\u0639\u0645\u0642\u0629 \u0639\u0644\u0649 \u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u062a\u0642\u0639 \u0623\u0648\u0627\u0645\u0631 DML \u0641\u064a \u0642\u0644\u0628 SQL \u0648\u062a\u0633\u0645\u062d \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0628\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u062e\u0632\u0646\u0629 \u062f\u0627\u062e\u0644 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u062a\u062a\u0636\u0645\u0646 \u0627\u0644\u0623\u0648\u0627\u0645\u0631 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0627\u0644\u0623\u0631\u0628\u0639\u0629 \u062f\u0627\u062e\u0644 DML \u0645\u0627 \u064a\u0644\u064a:<\/p>\n<ol>\n<li><strong>\u064a\u062e\u062a\u0627\u0631<\/strong>: \u064a\u0633\u062a\u062e\u062f\u0645 \u0644\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0639\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0633\u062a\u0631\u062c\u0627\u0639\u0647\u0627 \u0645\u0646 \u062c\u062f\u0648\u0644 \u0648\u0627\u062d\u062f \u0623\u0648 \u0623\u0643\u062b\u0631 \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<li><strong>\u0625\u062f\u0631\u0627\u062c<\/strong>: \u0625\u0636\u0627\u0641\u0629 \u0633\u062c\u0644\u0627\u062a \u062c\u062f\u064a\u062f\u0629 \u0625\u0644\u0649 \u0627\u0644\u062c\u062f\u0648\u0644.<\/li>\n<li><strong>\u062a\u062d\u062f\u064a\u062b<\/strong>: \u062a\u0639\u062f\u064a\u0644 \u0627\u0644\u0633\u062c\u0644\u0627\u062a \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u062c\u062f\u0648\u0644.<\/li>\n<li><strong>\u064a\u0645\u0633\u062d<\/strong>: \u0625\u0632\u0627\u0644\u0629 \u0627\u0644\u0633\u062c\u0644\u0627\u062a \u0645\u0646 \u0627\u0644\u062c\u062f\u0648\u0644.<\/li>\n<\/ol>\n<p>\u0645\u0646 \u0627\u0644\u0645\u0647\u0645 \u0623\u0646 \u0646\u0641\u0647\u0645 \u0623\u0646 \u0647\u0630\u0647 \u0627\u0644\u0623\u0648\u0627\u0645\u0631\u060c \u0648\u062e\u0627\u0635\u0629 UPDATE \u0648DELETE\u060c \u064a\u0645\u0643\u0646\u0647\u0627 \u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062f\u0627\u062e\u0644 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0643\u0628\u064a\u0631. \u0648\u0644\u0630\u0644\u0643\u060c \u0641\u0645\u0646 \u0627\u0644\u0623\u0641\u0636\u0644 \u062a\u0646\u0641\u064a\u0630 \u0645\u062b\u0644 \u0647\u0630\u0647 \u0627\u0644\u0623\u0648\u0627\u0645\u0631 \u0628\u062d\u0630\u0631.<\/p>\n<h2>\u0627\u0644\u0623\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u062e\u0644\u064a\u0629 \u0644\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0639\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u060c \u064a\u0639\u0645\u0644 DML \u0639\u0646 \u0637\u0631\u064a\u0642 \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0623\u0648\u0627\u0645\u0631 \u0625\u0644\u0649 \u0646\u0638\u0627\u0645 \u0625\u062f\u0627\u0631\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u064a\u0642\u0648\u0645 \u0646\u0638\u0627\u0645 \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (DBMS) \u0628\u062a\u0641\u0633\u064a\u0631 \u0647\u0630\u0647 \u0627\u0644\u0623\u0648\u0627\u0645\u0631\u060c \u0648\u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629 \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0625\u0631\u062c\u0627\u0639 \u0623\u064a \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0637\u0644\u0648\u0628\u0629 \u0625\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645. \u064a\u062a\u0639\u0627\u0645\u0644 \u0646\u0638\u0627\u0645 \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a (DBMS) \u0645\u0639 \u062c\u0645\u064a\u0639 \u062a\u0639\u0642\u064a\u062f\u0627\u062a \u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062e\u0632\u064a\u0646\u0647\u0627\u060c \u0645\u0645\u0627 \u064a\u062a\u064a\u062d \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u062a\u0641\u0627\u0639\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u0648\u0627\u0645\u0631 \u0628\u0633\u064a\u0637\u0629 \u0646\u0633\u0628\u064a\u064b\u0627.<\/p>\n<p>\u0641\u064a\u0645\u0627 \u064a\u062a\u0639\u0644\u0642 \u0628\u0627\u0644\u062a\u0646\u0641\u064a\u0630\u060c \u064a\u0642\u0648\u0645 \u0646\u0638\u0627\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0645\u0639\u0627\u0644\u062c\u0629 \u0623\u0645\u0631 DML \u0639\u0644\u0649 \u0645\u0631\u062d\u0644\u062a\u064a\u0646:<\/p>\n<ol>\n<li><strong>\u0648\u0642\u062a \u0627\u0644\u062a\u0631\u062c\u0645\u0629<\/strong>: \u064a\u062a\u0645 \u0627\u0644\u062a\u062d\u0642\u0642 \u0645\u0646 \u0628\u0646\u0627\u0621 \u062c\u0645\u0644\u0629 \u0639\u0628\u0627\u0631\u0629 SQL.<\/li>\n<li><strong>\u0645\u062f\u0629 \u0627\u0644\u0639\u0631\u0636<\/strong>: \u064a\u0642\u0648\u0645 \u0646\u0638\u0627\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u062a\u0646\u0641\u064a\u0630 \u0639\u0628\u0627\u0631\u0629 SQL \u0648\u064a\u0642\u0648\u0645 \u0628\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<\/ol>\n<h2>\u0627\u0644\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 \u0644\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u062a\u062a\u0636\u0645\u0646 \u0628\u0639\u0636 \u0627\u0644\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0647\u0627\u0645\u0629 \u0644\u0640 DML \u0645\u0627 \u064a\u0644\u064a:<\/p>\n<ul>\n<li><strong>\u0628\u0633\u0627\u0637\u0629<\/strong>: \u0623\u0648\u0627\u0645\u0631 DML \u0628\u0633\u064a\u0637\u0629 \u0648\u0633\u0647\u0644\u0629 \u0627\u0644\u0641\u0647\u0645.<\/li>\n<li><strong>\u0627\u0644\u0645\u0631\u0648\u0646\u0629<\/strong>: \u064a\u0633\u0645\u062d DML \u0628\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0644\u0649 \u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u062a\u0633\u062c\u064a\u0644 \u0648\u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u062d\u062f\u062f.<\/li>\n<li><strong>\u0645\u0639\u0627\u0644\u062c\u0629 \u0642\u0648\u064a\u0629 \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong>: \u064a\u0645\u0643\u0646 \u0644\u0640 DML \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0629 \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0643\u0641\u0627\u0621\u0629.<\/li>\n<li><strong>\u062a\u0646\u0627\u0633\u0642 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong>: \u064a\u0636\u0645\u0646 DML \u0633\u0644\u0627\u0645\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u062a\u0633\u0627\u0642\u0647\u0627 \u062f\u0627\u062e\u0644 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<\/ul>\n<h2>\u0623\u0646\u0648\u0627\u0639 \u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0647\u0646\u0627\u0643 \u0646\u0648\u0639\u0627\u0646 \u0645\u0646 DML:<\/p>\n<ol>\n<li><strong>DML \u0627\u0644\u0625\u062c\u0631\u0627\u0626\u064a\u0629<\/strong>: \u064a\u062a\u0637\u0644\u0628 \u0645\u0646 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629 \u0648\u0643\u064a\u0641\u064a\u0629 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u064a\u0647\u0627.<\/li>\n<li><strong>DML \u063a\u064a\u0631 \u0627\u0644\u0625\u062c\u0631\u0627\u0626\u064a\u0629<\/strong>: \u064a\u062a\u0637\u0644\u0628 \u0645\u0646 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629 \u062f\u0648\u0646 \u062a\u062d\u062f\u064a\u062f \u0643\u064a\u0641\u064a\u0629 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u064a\u0647\u0627.<\/li>\n<\/ol>\n<p>\u0648\u064a\u0642\u062f\u0645 \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u062a\u0627\u0644\u064a \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u064a\u0646 \u0627\u0644\u0646\u0648\u0639\u064a\u0646:<\/p>\n<table>\n<thead>\n<tr>\n<th>\u0645\u064a\u0632\u0629<\/th>\n<th>DML \u0627\u0644\u0625\u062c\u0631\u0627\u0626\u064a\u0629<\/th>\n<th>DML \u063a\u064a\u0631 \u0627\u0644\u0625\u062c\u0631\u0627\u0626\u064a\u0629<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0633\u0647\u0648\u0644\u0629 \u0627\u0644\u0627\u0633\u062a\u0639\u0645\u0627\u0644<\/td>\n<td>\u064a\u062a\u0637\u0644\u0628 \u0645\u0639\u0631\u0641\u0629 \u0643\u064a\u0641\u064a\u0629 \u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/td>\n<td>\u0623\u0633\u0647\u0644 \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646\u060c \u0648\u064a\u062a\u0637\u0644\u0628 \u0641\u0642\u0637 \u0645\u0639\u0631\u0641\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629<\/td>\n<\/tr>\n<tr>\n<td>\u0643\u0641\u0627\u0621\u0629<\/td>\n<td>\u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u062d\u064a\u062b \u064a\u0645\u0643\u0646 \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u062a\u0648\u062c\u064a\u0647 \u0627\u0644\u0646\u0638\u0627\u0645 \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u062a\u062d\u062f\u064a\u062f\u064b\u0627<\/td>\n<td>\u0642\u062f \u064a\u0643\u0648\u0646 \u0623\u0642\u0644 \u0643\u0641\u0627\u0621\u0629 \u062d\u064a\u062b \u064a\u062c\u0628 \u0639\u0644\u0649 \u0627\u0644\u0646\u0638\u0627\u0645 \u062a\u062d\u062f\u064a\u062f \u0623\u0641\u0636\u0644 \u0637\u0631\u064a\u0642\u0629 \u0644\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/td>\n<\/tr>\n<tr>\n<td>\u0623\u0645\u062b\u0644\u0629<\/td>\n<td>SQL \u0639\u0646\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u0645\u0639 JOIN \u0648WHERE \u0648\u0627\u0644\u0623\u0648\u0627\u0645\u0631 \u0627\u0644\u0645\u0634\u0627\u0628\u0647\u0629 \u0627\u0644\u0623\u062e\u0631\u0649<\/td>\n<td>SQL \u0639\u0646\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u0645\u0639 \u0639\u0628\u0627\u0631\u0627\u062a SELECT \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0648\u0627\u0644\u0642\u0636\u0627\u064a\u0627 \u0648\u0627\u0644\u062d\u0644\u0648\u0644 \u0641\u064a \u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u064a\u062a\u0645 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 DML \u0639\u0644\u0649 \u0646\u0637\u0627\u0642 \u0648\u0627\u0633\u0639 \u0641\u064a \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a\u060c \u0628\u062f\u0621\u064b\u0627 \u0645\u0646 \u0627\u0633\u062a\u0631\u062c\u0627\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0628\u0633\u064a\u0637\u0629 \u0644\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u062d\u062a\u0649 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629 \u062f\u0627\u062e\u0644 \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0628\u0631\u0627\u0645\u062c. \u0648\u0645\u0639 \u0630\u0644\u0643\u060c \u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0624\u062f\u064a \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u063a\u064a\u0631 \u0627\u0644\u0633\u0644\u064a\u0645 \u0644\u0640 DML \u0625\u0644\u0649 \u062a\u0644\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0641\u0642\u062f\u0627\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0645\u0634\u0643\u0644\u0627\u062a \u0641\u064a \u0627\u0644\u0623\u062f\u0627\u0621.<\/p>\n<p>\u0644\u0644\u062a\u062e\u0641\u064a\u0641 \u0645\u0646 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0643\u0644\u0627\u062a\u060c \u062a\u062a\u0636\u0645\u0646 \u0628\u0639\u0636 \u0623\u0641\u0636\u0644 \u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0627\u062a \u0645\u0627 \u064a\u0644\u064a:<\/p>\n<ul>\n<li>\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0644\u0636\u0645\u0627\u0646 \u0633\u0644\u0627\u0645\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<li>\u0627\u0644\u062d\u062f \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u0648\u0627\u0645\u0631 DELETE \u0648UPDATE \u0644\u0645\u0646\u0639 \u0641\u0642\u062f\u0627\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u063a\u064a\u0631 \u0627\u0644\u0645\u0642\u0635\u0648\u062f.<\/li>\n<li>\u0627\u0644\u0646\u0633\u062e \u0627\u0644\u0627\u062d\u062a\u064a\u0627\u0637\u064a \u0644\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0627\u0646\u062a\u0638\u0627\u0645.<\/li>\n<li>\u062a\u0637\u0628\u064a\u0642 \u0623\u0630\u0648\u0646\u0627\u062a \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u0629 \u0644\u062a\u062d\u062f\u064a\u062f \u0645\u0646 \u064a\u0645\u0643\u0646\u0647 \u062a\u0646\u0641\u064a\u0630 \u0623\u0648\u0627\u0645\u0631 DML.<\/li>\n<\/ul>\n<h2>\u0645\u0642\u0627\u0631\u0646\u0627\u062a \u0645\u0639 \u0644\u063a\u0627\u062a \u0645\u0645\u0627\u062b\u0644\u0629<\/h2>\n<p>\u0641\u064a \u062d\u064a\u0646 \u0623\u0646 SQL \u0648\u0628\u0627\u0644\u062a\u0627\u0644\u064a DML \u0623\u0635\u0628\u062d\u062a \u0623\u062f\u0648\u0627\u062a \u0642\u064a\u0627\u0633\u064a\u0629 \u0641\u064a \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0641\u0625\u0646 \u0627\u0644\u0644\u063a\u0627\u062a \u0627\u0644\u0623\u062e\u0631\u0649 \u062a\u0648\u0641\u0631 \u0623\u064a\u0636\u064b\u0627 \u0625\u0645\u0643\u0627\u0646\u0627\u062a \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u0647\u0646\u0627\u0643 \u0645\u062b\u0627\u0644\u0627\u0646 \u0628\u0627\u0631\u0632\u0627\u0646 \u0647\u0645\u0627 XQuery \u0644\u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a XML \u0648SPARQL \u0644\u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a RDF.<\/p>\n<p>\u062a\u062a\u0645\u064a\u0632 \u0647\u0630\u0647 \u0627\u0644\u0644\u063a\u0627\u062a \u0628\u062a\u0631\u0643\u064a\u0632 \u0645\u062e\u062a\u0644\u0641 \u0639\u0646 SQL \u0648DML\u060c \u062d\u064a\u062b \u064a\u0631\u0643\u0632 XQuery \u0639\u0644\u0649 \u0647\u064a\u0627\u0643\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0634\u0627\u0628\u0647\u0629 \u0644\u0644\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0628\u064a\u0646\u0645\u0627 \u064a\u0631\u0643\u0632 SPARQL \u0639\u0644\u0649 \u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0648\u064a\u0628 \u0627\u0644\u062f\u0644\u0627\u0644\u064a\u0629. \u0648\u0645\u0639 \u0630\u0644\u0643\u060c \u0641\u0647\u064a \u062a\u0648\u0641\u0631 \u0625\u0645\u0643\u0627\u0646\u0627\u062a \u0645\u0634\u0627\u0628\u0647\u0629 \u0644\u0623\u0648\u0627\u0645\u0631 SELECT \u0648INSERT \u0648UPDATE \u0648DELETE \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a DML.<\/p>\n<h2>\u0627\u0644\u0622\u0641\u0627\u0642 \u0627\u0644\u0645\u0633\u062a\u0642\u0628\u0644\u064a\u0629 \u0644\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0648\u0628\u0645\u0627 \u0623\u0646 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0627 \u062a\u0632\u0627\u0644 \u062a\u0634\u0643\u0644 \u062d\u062c\u0631 \u0627\u0644\u0632\u0627\u0648\u064a\u0629 \u0641\u064a \u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a\u060c \u0641\u0625\u0646 \u0623\u0647\u0645\u064a\u0629 DML \u0633\u062a\u0638\u0644 \u0643\u0628\u064a\u0631\u0629. \u0644\u0642\u062f \u062e\u0644\u0642\u062a \u0627\u0644\u062a\u0637\u0648\u0631\u0627\u062a \u0645\u062b\u0644 \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a NoSQL \u0648\u0645\u0646\u0635\u0627\u062a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0636\u062e\u0645\u0629 \u062a\u062d\u062f\u064a\u0627\u062a \u0648\u0641\u0631\u0635\u064b\u0627 \u062c\u062f\u064a\u062f\u0629. \u0633\u064a\u0643\u0648\u0646 \u062a\u0637\u0648\u0631 DML\u060c \u0623\u0648 \u062a\u0637\u0648\u064a\u0631 \u0644\u063a\u0627\u062a \u062c\u062f\u064a\u062f\u0629 \u0644\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0647\u0630\u0647 \u0627\u0644\u062a\u062d\u062f\u064a\u0627\u062a\u060c \u0628\u0645\u062b\u0627\u0628\u0629 \u0645\u0633\u0627\u062d\u0629 \u0631\u0627\u0626\u0639\u0629 \u0644\u0644\u0645\u0634\u0627\u0647\u062f\u0629.<\/p>\n<h2>\u062a\u0642\u0627\u0637\u0639 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644\u0629 \u0648\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u064a\u0639\u0645\u0644 \u0627\u0644\u062e\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644 \u0643\u0648\u0633\u064a\u0637 \u0628\u064a\u0646 \u0627\u0644\u0639\u0645\u064a\u0644 \u0627\u0644\u0630\u064a \u064a\u0628\u062d\u062b \u0639\u0646 \u0645\u0648\u0627\u0631\u062f \u0645\u0646 \u062e\u0648\u0627\u062f\u0645 \u0623\u062e\u0631\u0649. \u0639\u0644\u0649 \u0627\u0644\u0631\u063a\u0645 \u0645\u0646 \u0623\u0646 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644\u0629 \u0644\u0627 \u062a\u062a\u0641\u0627\u0639\u0644 \u0628\u0637\u0628\u064a\u0639\u062a\u0647\u0627 \u0645\u0639 DML\u060c \u0625\u0644\u0627 \u0623\u0646\u0647\u0627 \u064a\u0645\u0643\u0646 \u0623\u0646 \u062a\u0644\u0639\u0628 \u062f\u0648\u0631\u064b\u0627 \u0641\u064a \u0625\u062f\u0627\u0631\u0629 \u0637\u0644\u0628\u0627\u062a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u062d\u0641\u0627\u0638 \u0639\u0644\u0649 \u0627\u0644\u0623\u0645\u0627\u0646 \u0648\u0625\u062e\u0641\u0627\u0621 \u0627\u0644\u0647\u0648\u064a\u0629.<\/p>\n<p>\u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u064a\u0645\u0643\u0646 \u062a\u0643\u0648\u064a\u0646 \u062e\u0627\u062f\u0645 \u0648\u0643\u064a\u0644 \u0644\u0645\u0648\u0627\u0632\u0646\u0629 \u062a\u062d\u0645\u064a\u0644 \u0637\u0644\u0628\u0627\u062a DML \u0639\u0628\u0631 \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u062a\u0639\u062f\u062f\u0629\u060c \u0645\u0645\u0627 \u064a\u0624\u062f\u064a \u0625\u0644\u0649 \u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621. \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u0630\u0644\u0643\u060c \u0645\u0646 \u062e\u0644\u0627\u0644 \u062a\u0648\u062c\u064a\u0647 \u0637\u0644\u0628\u0627\u062a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u062e\u0644\u0627\u0644 \u062e\u0627\u062f\u0645 \u0648\u0643\u064a\u0644\u060c \u062a\u062a\u0645 \u0625\u0636\u0627\u0641\u0629 \u0637\u0628\u0642\u0629 \u0625\u0636\u0627\u0641\u064a\u0629 \u0645\u0646 \u0625\u062e\u0641\u0627\u0621 \u0627\u0644\u0647\u0648\u064a\u0629 \u0648\u0627\u0644\u0623\u0645\u0627\u0646 \u0625\u0644\u0649 \u0639\u0645\u0644\u064a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0645\u0645\u0627 \u064a\u0642\u0644\u0644 \u0645\u0646 \u0645\u062e\u0627\u0637\u0631 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0636\u0627\u0631\u0629.<\/p>\n<h2>\u0631\u0648\u0627\u0628\u0637 \u0630\u0627\u062a \u0639\u0644\u0627\u0642\u0629<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/default.asp\" target=\"_new\" rel=\"noopener nofollow\">\u062f\u0631\u0648\u0633 SQL \u0645\u0646 W3Schools<\/a><\/li>\n<li><a href=\"https:\/\/www.dataversity.net\/sql-foundation-data-manipulation\/\" target=\"_new\" rel=\"noopener nofollow\">SQL: \u0623\u0633\u0627\u0633 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14200\/statements_10002.htm\" target=\"_new\" rel=\"noopener nofollow\">\u0644\u063a\u0629 \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0634\u0631\u0643\u0629 \u0623\u0648\u0631\u0627\u0643\u0644<\/a><\/li>\n<\/ul>\n<p>\u0645\u0646 \u062e\u0644\u0627\u0644 \u0641\u0647\u0645 DML \u0648\u0627\u0644\u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646\u0647 \u0628\u0634\u0643\u0644 \u0635\u062d\u064a\u062d\u060c \u064a\u0645\u0643\u0646 \u0644\u0644\u0645\u0631\u0621 \u0627\u0644\u062a\u0641\u0627\u0639\u0644 \u0628\u0634\u0643\u0644 \u0641\u0639\u0627\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0645\u0639\u0627\u0644\u062c\u062a\u0647\u0627 \u062f\u0627\u062e\u0644 \u0628\u064a\u0626\u0629 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646\u0638\u0645\u0629\u060c \u0648\u0647\u064a \u0645\u0647\u0627\u0631\u0629 \u0628\u0627\u0644\u063a\u0629 \u0627\u0644\u0623\u0647\u0645\u064a\u0629 \u0641\u064a \u0639\u0627\u0644\u0645\u0646\u0627 \u0627\u0644\u0630\u064a \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0645\u062a\u0632\u0627\u064a\u062f.<\/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\/ar\/wp-json\/wp\/v2\/wiki\/476664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/wiki\/476664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/media\/476665"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/media?parent=476664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}