{"id":7684,"date":"2021-01-28T11:01:31","date_gmt":"2021-01-28T11:01:31","guid":{"rendered":"https:\/\/mehdisalimi.ir\/?p=7684"},"modified":"2021-01-28T12:08:56","modified_gmt":"2021-01-28T12:08:56","slug":"%e2%80%8c%d9%be%d8%b1%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%d8%af%d8%aa%d8%b1%db%8c%d9%86-%d8%af%d8%b3%d8%aa%d9%88%d8%b1%d8%a7%d8%aa-sql","status":"publish","type":"post","link":"https:\/\/mehdisalimi.ir\/?p=7684","title":{"rendered":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL"},"content":{"rendered":"

\u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0648\u0644\u0641\u0647\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0647\u0633\u062a\u0646\u062f. \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062f\u0633\u06a9\u062a\u0627\u067e\u06cc\u060c \u0648\u0628\u200c\u0645\u062d\u0648\u0631 \u0648 \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0632\u0645\u0627\u0646\u06cc\u200c\u06a9\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0633\u0627\u062e\u062a\u200c\u06cc\u0627\u0641\u062a\u0647 (SQL) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0633\u0647\u0648\u0644\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u0648 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc \u0628\u0627\u0644\u0642\u0648\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f. \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u0647\u0645\u06cc\u062a \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0633\u0627\u062e\u062a\u200c\u06cc\u0627\u0641\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u067e\u0631\u06a9\u0627\u0631\u062f\u0628\u0631 SQL \u0631\u0627 \u0645\u0639\u0631\u0641\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u062f\u0647\u0645.<\/span><\/p>\n

<\/p>\n

\u200c\u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0628\u0631 \u0645\u0628\u0646\u0627\u06cc \u0686\u0647\u0627\u0631 \u062c\u062f\u0648\u0644 \u0633\u0627\u062f\u0647 \u0646\u06af\u0627\u0631\u0634 \u0634\u062f\u0647\u200c\u0627\u0646\u062f. \u062a\u0648\u0636\u06cc\u062d \u0627\u06cc\u0646 \u062c\u062f\u0627\u0648\u0644 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n

\u062c\u062f\u0648\u0644 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 (customer) \u0634\u0627\u0645\u0644 \u0646\u0627\u0645 \u0648 \u0633\u0646 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0627\u0633\u062a (\u0634\u06a9\u0644 \u06f1).<\/span><\/p>\n

\"\"<\/p>\n

\u062c\u062f\u0648\u0644 \u0642\u062f (heights) \u0634\u0627\u0645\u0644 \u0646\u0627\u0645 \u0648 \u0642\u062f \u0627\u0641\u0631\u0627\u062f \u0627\u0633\u062a (\u0634\u06a9\u0644 \u06f2).<\/span><\/p>\n

\"\"<\/p>\n

\u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u06a9\u0646\u0627\u0646 \u0645\u0634\u0627\u0628\u0647 \u062c\u062f\u0648\u0644 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0646\u0627\u0645 \u0648 \u0633\u0646 \u06a9\u0627\u0631\u06a9\u0646\u0627\u0646 \u0631\u0627 \u0634\u0627\u0645\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f (\u0634\u06a9\u0644 \u06f3).<\/span><\/p>\n

\"\"<\/p>\n

\u062c\u062f\u0648\u0644 \u0627\u0641\u0631\u0627\u062f \u0634\u0628\u06cc\u0647 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u0645\u0634\u062a\u0631\u06cc\u0627\u0646 \u0648 \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0646\u0627\u0645 \u0648 \u0633\u0646 \u0627\u0641\u0631\u0627\u062f \u0631\u0627 \u0634\u0627\u0645\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f (\u0634\u06a9\u0644 \u06f4).<\/span><\/p>\n

\"\"<\/p>\n

\u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u0645 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u0627\u062a\u0631 \u0634\u062f\u0646 \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0647\u0627\u060c \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647\u200c\u0647\u0627\u06cc \u0632\u0628\u0627\u0646 SQL \u0631\u0627 \u0628\u0627 \u062d\u0631\u0648\u0641 \u0628\u0632\u0631\u06af \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u062a\u0627 \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u062f\u0631\u06a9 \u0622\u0646\u200c\u0647\u0627 \u0633\u0627\u062f\u0647 \u0634\u0648\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u0645\u0642\u062f\u0645\u0647 \u06a9\u0648\u062a\u0627\u0647 \u0628\u0647 \u0633\u0631\u0627\u063a \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u067e\u0631 \u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u0633\u200c\u06a9\u06cc\u0648\u200c\u0627\u0644 \u0645\u06cc\u200c\u0631\u0648\u06cc\u0645.<\/span><\/p>\n

\u06f1- \u062f\u0633\u062a\u0648\u0631 Select<\/span><\/strong>
\n\u200c\u062f\u0633\u062a\u0648\u0631 Select \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u06cc\u06a9\u06cc \u0627\u0632 \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u0633\u200c\u06a9\u06cc\u0648\u0627\u0644 \u0627\u0633\u062a. Select \u0627\u0648\u0644\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0647\u0631 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u0647\u200c\u0627\u06cc \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f\u060c \u0632\u06cc\u0631\u0627 \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n

SELECT * FROM table;<\/pre>\n
\u200c\u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0627\u0632 \u062f\u0648 \u0628\u062e\u0634 \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0628\u062e\u0634 \u0627\u0648\u0644 SELECT * \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0642\u0635\u062f \u0627\u0646\u062a\u062e\u0627\u0628 \u0686\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645. \u062f\u0631 \u0645\u062b\u0627\u0644 \u0641\u0648\u0642 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u0633\u062a\u0627\u0631\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0639\u0646\u0627 \u0627\u0633\u062a \u06a9\u0647 \u0647\u062f\u0641 \u0645\u0627 \u062a\u0645\u0627\u0645\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0627\u0633\u062a. \u0628\u062e\u0634 \u062f\u0648\u0645 FROM table \u0628\u0647 \u062c\u062f\u0648\u0644\u06cc \u062f\u0631\u0648\u0646 \u0628\u0627\u0646\u06a9\u200c\u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06a9\u0647 \u0642\u0635\u062f \u0648\u0627\u06a9\u0627\u0648\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0622\u0646\u200c\u0631\u0627 \u062f\u0627\u0631\u06cc\u0645 \u0627\u0634\u0627\u0631\u0647 \u062f\u0627\u0631\u062f. \u062f\u0631 \u0645\u062b\u0627\u0644 \u0641\u0648\u0642 \u0628\u0647\u200c\u062c\u0627\u06cc \u0648\u0627\u0698\u0647 table \u0628\u0627\u06cc\u062f \u0646\u0627\u0645 \u062c\u062f\u0648\u0644\u06cc \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0634\u0648\u062f \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0622\u0646 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0634\u0648\u062f. \u0645\u062b\u0627\u0644 \u0641\u0648\u0642 \u0628\u0647\u200c\u0646\u0627\u0645 \u062f\u0633\u062a\u0648\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u062a\u0627\u0631\u0647 (select star) \u0646\u06cc\u0632 \u0645\u0639\u0631\u0648\u0641 \u0627\u0633\u062a. \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 * \u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u062a\u0645\u0627\u0645\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062f\u0631\u0648\u0646 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062e\u0648\u0628 \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u06a9\u0645\u062a\u0631 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0632\u06cc\u0631\u0627 \u0647\u06cc\u0686 \u0645\u06a9\u0627\u0646\u06cc\u0632\u0645 \u06a9\u0646\u062a\u0631\u0644\u06cc \u0631\u0648\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0627\u0632\u06af\u0634\u062a\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f. \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062f\u0633\u062a\u0648\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u0633\u062a\u0627\u0631\u0647\u200c\u0627\u06cc \u0631\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u0628\u0627\u0646\u06a9\u200c\u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062a\u0645\u0627\u0645\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0647\u062f\u0641 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0631\u0627 \u0645\u06cc\u200c\u200c\u062a\u0648\u0627\u0646 \u06a9\u0645\u06cc \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0647 \u0634\u06a9\u0644 \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0632\u06cc\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f:<\/span><\/p>\n
SELECT age, name FROM people;<\/pre>\n
\u200c\u062f\u0631 \u0645\u062d\u0627\u0648\u0631\u0647 \u0628\u0627\u0644\u0627 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062f\u0631\u0648\u0646 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc age \u0648 name \u0627\u0632 \u062c\u062f\u0648\u0644 people \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u062f\u0633\u062a\u0648\u0631 Select \u0647\u0631\u0686\u0647 \u062f\u0642\u06cc\u0642\u200c\u062a\u0631 \u0648 \u062c\u0627\u0645\u0639\u200c\u062a\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f\u060c \u0646\u062a\u0627\u06cc\u062c \u062e\u0644\u0627\u0635\u0647\u200c\u062a\u0631\u06cc \u0631\u0627 \u0628\u0627\u0632 \u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0648 \u0645\u0627\u0646\u0639 \u0628\u0631\u0648\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u06a9\u0648\u0631\u062f \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u062e\u0627\u0635\u06cc \u0647\u0633\u062a\u06cc\u062f \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0645\u0634\u0627\u0628\u0647 \u062d\u0627\u0644\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
SELECT age, '1234' FROM people;<\/pre>\n
\"\"<\/p>\n
\u06f2- \u0641\u0631\u0645\u0627\u0646 WHERE<\/span><\/strong>
\n\u200c\u0641\u0631\u0645\u0627\u0646 SELECT \u0628\u0631\u0627\u06cc \u0648\u0627\u06a9\u0634\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u062f\u0631\u062c \u0641\u06cc\u0644\u062a\u0631\u06cc \u0631\u0648\u06cc \u0646\u062a\u0627\u06cc\u062c \u0628\u0627\u0634\u06cc\u0645 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0641\u06a9\u0631 \u0631\u0627\u0647\u06a9\u0627\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631\u06cc \u0628\u0627\u0634\u06cc\u0645. \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 \u062f\u0631 \u062c\u0633\u062a\u200c\u0648\u062c\u0648\u06cc \u0627\u0641\u0631\u0627\u062f\u06cc \u0647\u0633\u062a\u06cc\u062f \u06a9\u0647 \u0633\u0646 \u0645\u0634\u062e\u0635\u06cc \u062f\u0627\u0631\u0646\u062f\u060c \u0628\u0627\u06cc\u062f \u0627\u0632 \u06cc\u06a9 \u0627\u0644\u06af\u0648\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u062f\u0631\u0633\u062a \u0647\u0645\u0627\u0646 \u0646\u0642\u0637\u0647\u200c\u0627\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0633\u062a\u0648\u0631 WHERE \u06a9\u0627\u0631\u0628\u0631\u062f \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0634\u0631\u0648\u0637\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 SELECT \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u062f. WHERE \u062f\u0631 \u0627\u0646\u062a\u0647\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 SELECT \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc WHERE \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age, name FROM people WHERE age > 10;<\/pre>\n
\"\"<\/p>\n
\u200c\u200c\u0639\u0645\u0644\u06af\u0631 AND<\/span>
\n\u0645\u062d\u0627\u0648\u0631\u0647 \u0628\u0627\u0644\u0627 \u0645\u062d\u062f\u0648\u062f \u0628\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0633\u0646 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u06f1\u06f0 \u0633\u0627\u0644 \u062f\u0627\u0631\u0646\u062f. \u0639\u0645\u0644\u06af\u0631 AND \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0686\u0646\u062f \u0634\u0631\u0637 \u0631\u0627 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0631\u062f.<\/span><\/p>\n
SELECT age, name FROM people WHERE age > AND age < 20;<\/pre>\n
\u200c\u062f\u0633\u062a\u0648\u0631 AND \u06a9\u0627\u0631\u06a9\u0631\u062f\u06cc \u0645\u0634\u0627\u0628\u0647 \u0628\u0627 \u0627\u0644\u06af\u0648\u06cc\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0634\u0631\u0637 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u0628\u0647 \u0639\u0628\u0627\u0631\u062a \u0645\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627\u060c \u062a\u0646\u0647\u0627 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc \u06a9\u0647 \u0633\u0646 \u0622\u0646\u200c\u0647\u0627 \u062f\u0631 \u0628\u0627\u0632\u0647 \u06f1\u06f0 \u062a\u0627 \u06f2\u06f0 \u0633\u0627\u0644 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u06cc\u0646\u200c\u06a9\u0647 \u062c\u062f\u0648\u0644 \u0645\u0627 \u0641\u0627\u0642\u062f \u0686\u0646\u06cc\u0646 \u0627\u0641\u0631\u0627\u062f\u06cc \u0627\u0633\u062a\u060c \u0647\u06cc\u0686 \u0631\u06a9\u0648\u0631\u062f \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0646\u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n
\u0639\u0645\u0644\u06af\u0631 OR<\/span>
\n\u200c\u200c\u0639\u0645\u0644\u06af\u0631 \u062f\u06cc\u06af\u0631 \u0642\u0627\u0628\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0627 \u0641\u0631\u0645\u0627\u0646 WHERE \u0639\u0645\u0644\u06af\u0631\u062f OR \u0627\u0633\u062a. \u0646\u062d\u0648\u0647 \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u0639\u0645\u0644\u06af\u0631 \u0641\u0648\u0642 \u062f\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0632\u06cc\u0631 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age, name FROM people WHERE age > 10 OR name = 'Joe';<\/pre>\n
\"\"<\/p>\n
\u0639\u0645\u0644\u06af\u0631 OR \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u06cc\u0627 \u0627\u0633\u062a. \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0627\u0632 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646\u200c\u0647\u0627 \u0633\u0646 \u0627\u0641\u0631\u0627\u062f \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u06f1\u06f0 \u0633\u0627\u0644 \u06cc\u0627 \u0646\u0627\u0645 \u0622\u0646\u200c\u0647\u0627 Joe \u0627\u0633\u062a. \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f \u062f\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0628\u0627\u0644\u0627 \u0627\u0632 \u06cc\u06a9 \u0639\u0644\u0627\u0645\u062a \u0645\u0633\u0627\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647\u060c \u0627\u0645\u0627 \u062f\u0631 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0632\u0628\u0627\u0646\u200c\u0647\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u062f\u0648 \u0639\u0644\u0627\u0645\u062a \u0645\u0633\u0627\u0648\u06cc (= =) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.<\/span><\/p>\n
\u06f3- \u062f\u0633\u062a\u0648\u0631 ORDER<\/span><\/strong>
\n\u200cORDER \u062f\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 SELECT \u0648 \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0646\u062a\u0627\u06cc\u062c \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0633\u0627\u062f\u0647 \u0628\u0648\u062f\u0647 \u0648 \u0627\u0646\u062a\u0647\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 SELECT \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n
SELECT name, age FROM people ORDER BY age DESC;<\/pre>\n
\"\"<\/p>\n
\u200c\u062f\u0631 \u062f\u0633\u062a\u0648\u0631 ORDER \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 ASC \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0635\u0639\u0648\u062f\u06cc \u0648 DESC \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0646\u0632\u0648\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0641\u0631\u0622\u06cc\u0646\u062f \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u0628\u0631 \u0645\u0628\u0646\u0627\u06cc \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0632\u06cc\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/span><\/p>\n
SELECT name, age FROM people ORDER BY name ASC, age DESC<\/pre>\n
\"\"<\/p>\n
\u200c\u0639\u0628\u0627\u0631\u062a ORDER BY \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u062a\u0631\u06a9\u06cc\u0628 \u0634\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0641\u06cc\u062f \u062e\u0648\u062f \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/span><\/p>\n
\u06f4- Join<\/span><\/strong>
\n\u200cJoin \u0628\u0631\u0627\u06cc \u0645\u062a\u0635\u0644 \u06a9\u0631\u062f\u0646 (\u0627\u0644\u062d\u0627\u0642) \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u06a9\u0647 \u062f\u0631 \u0686\u0646\u062f \u062c\u062f\u0648\u0644 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062c\u062f\u0648\u0644 \u062f\u0648\u0645 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0648\u0644 \u0645\u0631\u062a\u0628\u0637 \u0634\u0648\u062f \u0648 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0631\u062a\u0628\u0627\u0637 \u0645\u06cc\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 JOIN \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age, name, height FROM people LEFT JOIN heights USING (name);<\/pre>\n
\u200c\u062f\u0631 \u0632\u0645\u0627\u0646 \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0686\u0646\u062f \u0646\u06a9\u062a\u0647 \u0645\u0647\u0645 \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0632\u0645\u0627\u0646 \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0627\u06cc\u062f \u0628\u0647 \u062a\u0646\u0638\u06cc\u0645\u0627\u062aLEFT JOIN \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f. \u0645\u062b\u0627\u0644 \u0641\u0648\u0642 \u0627\u0639\u0644\u0627\u0645 \u0645\u06cc\u200c\u062f\u0627\u0631\u062f \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u062a\u0635\u0627\u0644 (\u0627\u0644\u062d\u0627\u0642) \u0627\u0632 \u0646\u0648\u0639 \u0627\u062a\u0635\u0627\u0644 \u0686\u067e \u0627\u0633\u062a. \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u062c\u062f\u0648\u0644\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0628\u0647 \u0622\u0646 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u0644\u062d\u0627\u0642 (heights) \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u0639\u0628\u0627\u0631\u062a USING (name) \u062f\u0631 \u067e\u0627\u06cc\u0627\u0646 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0627\u0639\u0644\u0627\u0645 \u0645\u06cc\u200c\u062f\u0627\u0631\u062f \u06a9\u0647 \u0633\u062a\u0648\u0646 name \u062f\u0631 \u0647\u0631 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0648 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f\u06cc \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u062c\u062f\u0627\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f. \u0627\u06af\u0631 \u062f\u0648 \u0633\u062a\u0648\u0646\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f \u0627\u062a\u0635\u0627\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u062f\u0631 \u062c\u062f\u0627\u0648\u0644 \u062f\u0627\u0631\u0646\u062f \u0628\u0647 \u062c\u0627\u06cc \u0639\u0628\u0627\u0631\u062a USING \u0627\u0632 ON \u0645\u0634\u0627\u0628\u0647 \u0628\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/span><\/p>\n
SELECT age, name, height FROM people LEFT JOIN heights ON (namea = nameb);<\/pre>\n
\"\"<\/p>\n
\u200c\u200c\u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 on \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0686\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u0628\u0627\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f. \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u062a\u0635\u0627\u0644 \u062d\u0627\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0645\u0646\u062f \u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u0632\u06cc\u0627\u062f\u06cc \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0628\u0647\u200c\u0637\u0648\u0631 \u06a9\u0644\u06cc \u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 JOIN \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0647\u0633\u062a\u0646\u062f:<\/span><\/p>\n
INNER JOIN:<\/span> \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0645\u0646\u0637\u0628\u0642 \u0647\u0631 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0628\u0631 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/span>
\nLEFT OUTER JOIN:<\/span> \u062a\u0645\u0627\u0645\u06cc \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0686\u067e \u0648 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0627\u0632 \u062c\u062f\u0648\u0644 \u0631\u0627\u0633\u062a \u06a9\u0647 \u0645\u0646\u0637\u0628\u0642 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0628\u0631 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u06af\u0631 \u0647\u06cc\u0686 \u0627\u0646\u0637\u0628\u0627\u0642\u06cc \u067e\u06cc\u062f\u0627 \u0646\u0634\u0648\u062f\u060c \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0686\u067e \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/span>
\nRIGHT OUTER JOIN:<\/span> \u0639\u0645\u0644\u06a9\u0631\u062f\u06cc \u0628\u0631\u0639\u06a9\u0633 \u062d\u0627\u0644\u062a \u0642\u0628\u0644 \u062f\u0627\u0631\u062f \u0648 \u062a\u0645\u0627\u0645\u06cc \u062c\u062f\u0627\u0648\u0644 \u0631\u0627\u0633\u062a \u0648 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc\u06cc \u0627\u0632 \u062c\u062f\u0648\u0644 \u0686\u067e \u06a9\u0647 \u0645\u0646\u0637\u0628\u0642 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/span>
\nFULL OUTER JOIN:<\/span> \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0647\u0631 \u062c\u062f\u0648\u0644 \u0645\u0646\u0637\u0628\u0642 \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0628\u0631 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/span>
\n\u062f\u0642\u062a \u06a9\u0646\u06cc\u062f \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u0648\u0627\u0698\u06af\u0627\u0646 INNER \u0648 OUTER \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u0627\u0633\u062a \u0648 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0631\u0627\u06cc \u0641\u0647\u0645 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/span><\/p>\n
\u06f5- \u0641\u0631\u0645\u0627\u0646 Alias<\/span><\/strong>
\n\u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0627\u0645 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06cc\u0627 \u0628\u0647 \u0639\u0628\u0627\u0631\u062a \u062f\u0642\u06cc\u0642\u200c\u062a\u0631 \u062a\u0639\u0631\u06cc\u0641 \u06cc\u06a9 \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u062a\u0646\u0647\u0627 \u062f\u0631\u0648\u0646 \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0631\u0648\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u062c\u0631\u0627 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0622\u0646 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT A.Age FROM people A;<\/pre>\n
\u200c\u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u0647\u0631 \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f\u060c \u0627\u0645\u0627 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u062d\u0631\u0648\u0641 \u0627\u0644\u0641\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0642\u0628\u0644 \u0627\u0632 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u060c \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u067e\u06cc\u0634\u0648\u0646\u062f \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0633\u062a\u0648\u0631 \u0628\u0627\u0644\u0627 \u0648 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0647\u0631 \u062f\u0648 \u06cc\u06a9\u0633\u0627\u0646 \u0647\u0633\u062a\u0646\u062f:<\/span><\/p>\n
SELECT people.Age FROM people;<\/pre>\n
\u200c\u0639\u0644\u062a \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 \u062f\u0631 \u06a9\u0648\u062a\u0627\u0647 \u06a9\u0631\u062f\u0646 \u0646\u0627\u0645 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062c\u062f\u0627\u0648\u0644 \u0627\u0633\u062a. \u062f\u0631 \u0637\u0631\u0627\u062d\u06cc\u200c\u0647\u0627\u06cc \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0646\u0627\u0645 \u062c\u062f\u0627\u0648\u0644 \u0627\u063a\u0644\u0628 \u0637\u0648\u0644\u0627\u0646\u06cc \u0647\u0633\u062a\u0646\u062f \u0648 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u062f\u0631 \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f \u0628\u0627\u0639\u062b \u0637\u0648\u0644\u0627\u0646\u06cc \u0634\u062f\u0646 \u06cc\u06a9 \u0645\u062d\u0627\u0648\u0631\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f\u060c \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0627\u0632 \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u0633\u0627\u062f\u0647 \u0648 \u06a9\u0648\u062a\u0627\u0647\u200c\u062a\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u062a\u0627 \u062f\u0631\u06a9 \u0645\u062d\u0627\u0648\u0631\u0647\u200c\u0647\u0627 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0634\u0648\u062f. \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0642\u0639 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u0633\u062a\u0648\u0646 \u06cc\u06a9\u0633\u0627\u0646\u06cc \u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u0639\u062f\u0645 \u0627\u0631\u062c\u0627\u0639 \u0635\u0631\u06cc\u062d \u0628\u0627\u0639\u062b \u0628\u0631\u0648\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a\u06cc \u062f\u0631 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0631\u0627\u06cc \u0631\u0648\u0634\u0646\u200c\u062a\u0631 \u0634\u062f\u0646 \u0628\u0647\u062a\u0631 \u0628\u062d\u062b \u0628\u0647 \u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n
SELECT staff.Age, staff.Name, customers.Age, customers.Name FROM staff, customers;<\/pre>\n
\u200c\u0647\u0645\u0627\u0646\u200c\u06af\u0648\u0646\u0647 \u06a9\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0645\u062d\u0627\u0648\u0631\u0647 \u0628\u0627\u0644\u0627 \u06a9\u0645\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a\u060c \u0627\u06a9\u0646\u0648\u0646 \u0647\u0645\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0631\u0627 \u0628\u0627 \u0633\u0628\u06a9 \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 \u0628\u0627\u0632\u0646\u0648\u06cc\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/span><\/p>\n
SELECT A.Age, A.Name, B.Age, B.Name FROM staff A, customers B;<\/pre>\n
\u200c\u0627\u06cc\u0646 \u0645\u0631\u062a\u0628\u0647 \u0628\u0647 \u062c\u0627\u06cc \u0646\u0627\u0645 \u062c\u062f\u0648\u0644 staff \u0627\u0632 \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 A \u0648 \u062c\u062f\u0648\u0644 customers \u0627\u0632 \u0646\u0627\u0645 \u0645\u0633\u062a\u0639\u0627\u0631 B \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645. \u0647\u0645\u0627\u0646\u200c\u06af\u0648\u0646\u0647 \u06a9\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06cc\u0648\u0647 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0648 \u0642\u0627\u0628\u0644 \u0641\u0647\u0645\u200c\u062a\u0631 \u0627\u0633\u062a. \u0628\u0631\u0627\u06cc \u0645\u0633\u062a\u0639\u0627\u0631\u0633\u0627\u0632\u06cc \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0646\u06cc\u0632 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 AS \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646\u200c\u06a9\u0627\u0631 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age AS person_age FROM people;<\/pre>\n
\"\"<\/p>\n
\u200c\u06f6- \u062f\u0633\u062a\u0648\u0631 Union<\/span><\/strong>
\nUnion \u06cc\u06a9\u06cc \u0627\u0632 \u067e\u0631 \u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u0648 \u0645\u0647\u0645\u200c\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u0627\u0633\u062a. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f. \u0628\u0631\u0639\u06a9\u0633 \u062f\u0633\u062a\u0648\u0631 JOINS \u06a9\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0645\u0631\u062a\u0628\u0637 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u062f\u0633\u062a\u0648\u0631 UNION \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u0631\u062a\u0628\u0637 \u0631\u0627 \u0628\u0647 \u0634\u0631\u0637 \u0627\u06cc\u0646\u200c\u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0648 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646 \u06cc\u06a9\u0633\u0627\u0646\u06cc \u0645\u0648\u062c\u0648\u062f \u0628\u0627\u0634\u062f \u0628\u0647 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0645\u062a\u0635\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age, name FROM customers UNION SELECT age, name FROM staff;<\/pre>\n
\"\"<\/p>\n
\u200c\u062f\u0633\u062a\u0648\u0631 UNION \u062f\u0631 \u062d\u0642\u06cc\u0642\u062a \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062a\u0627\u06cc\u062c \u062f\u0648 \u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u0633\u062a. \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 UNION ALL \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062a\u0645\u0627\u0645\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0635\u0631\u0641\u200c\u0646\u0638\u0631 \u0627\u0632 \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0648\u062f\u0646 \u0622\u0646\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0627\u06cc\u0646\u200c\u06a9\u0627\u0631 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
SELECT age, name FROM customers UNION ALL SELECT age, name FROM staff;<\/pre>\n
\"\"<\/p>\n
\u200c\u062f\u0642\u062a \u06a9\u0646\u06cc\u062f \u062f\u0631 \u062d\u0627\u0644\u062a \u0641\u0648\u0642 \u062a\u0631\u062a\u06cc\u0628 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0627\u0646 Union \u0628\u06cc\u0634\u062a\u0631 \u0628\u0631\u0627\u06cc \u06a9\u0645 \u06a9\u0631\u062f\u0646 \u062a\u0639\u062f\u0627\u062f \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0628\u0627\u0632\u06af\u0634\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062b\u0627\u0644\u060c \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u06cc\u06a9 \u0645\u062d\u0627\u0648\u0631\u0647 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u06cc\u06a9 \u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u200c\u0647\u0627\u06cc \u0645\u0646\u0641\u0631\u062f \u062a\u0642\u0644\u06cc\u0644 \u062f\u0627\u062f.<\/span><\/p>\n
\u06f7- \u0641\u0631\u0645\u0627\u0646 Insert<\/span><\/strong>
\n\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0627\u0632 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u06cc\u0645\u060c \u0646\u0648\u0628\u062a \u0628\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0641\u0631\u0627 \u0631\u0633\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0627\u0646 INSERT \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
INSERT INTO people(name, age) VALUES('Joe', 102);<\/pre>\n
\u200c\u062f\u0631 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0646\u0627\u0645 \u062c\u062f\u0648\u0644 people \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a\u06cc \u062f\u0631 \u0622\u0646\u200c\u0647\u0627 \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f name \u0648 age \u0647\u0633\u062a\u0646\u062f. \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc VALUES \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u062f\u0631\u062c \u0634\u0648\u0646\u062f \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0645\u0642\u0627\u062f\u06cc\u0631 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0628\u0627\u06cc\u062f \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0648 \u0647\u0645\u0627\u0647\u0646\u06af \u0628\u0627 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0628\u0627\u0634\u0646\u062f. \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0641\u0631\u0645\u0627\u0646 INSERT \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 WHERE \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u060c \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644 \u067e\u06cc\u0634 \u0627\u0632 \u062f\u0631\u062c \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0628\u0627\u06cc\u062f \u0646\u06a9\u0627\u062a \u0645\u062e\u062a\u0644\u0641 \u0628\u0647 \u062f\u0642\u062a \u0631\u0639\u0627\u06cc\u062a \u0634\u0648\u0646\u062f.<\/span><\/p>\n
\u06f8- \u062f\u0633\u062a\u0648\u0631 Update<\/span><\/strong>
\n\u200c\u062f\u0631 \u0647\u0631 \u0628\u0627\u0646\u06a9\u200c\u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a\u06cc \u062f\u0631 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0647 \u0648\u062c\u0648\u062f \u0622\u06cc\u062f. \u062f\u0633\u062a\u0648\u0631 UPDATE \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
UPDATE people SET name = 'Joe', age = 101;<\/pre>\n
\u200c\u200c\u062f\u0631 \u062f\u0633\u062a\u0648\u0631 UPDATE \u0628\u0627\u06cc\u062f \u0646\u0627\u0645 \u062c\u062f\u0648\u0644\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0622\u0646 \u0627\u0639\u0645\u0627\u0644 \u0634\u0648\u062f \u0645\u0634\u062e\u0635 \u0634\u0648\u062f. \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 SET \u0628\u0631\u0627\u06cc \u062a\u0639\u06cc\u06cc\u0646 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0642\u0628\u0644\u06cc \u0634\u0648\u0646\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645. \u062f\u0631 \u062f\u0633\u062a\u0648\u0631 UPDATE \u0627\u0645\u06a9\u0627\u0646 \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 WHERE \u0645\u0634\u0627\u0628\u0647 \u0628\u0627 \u0641\u0631\u0645\u0627\u0646 SELECT \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646\u200c\u06a9\u0627\u0631 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
UPDATE people SET name = 'Joe', age = 101 WHERE name = 'James';<\/pre>\n
\u200c\u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u0639\u0645\u0644\u06af\u0631\u0647\u0627\u06cc AND \u0648 OR \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0634\u0631\u0648\u0637 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f:<\/span><\/p>\n
UPDATE people SET name = 'Joe', age = 101 WHERE (name = 'James' AND age = 100) OR name = 'Ryan';<\/pre>\n
\u200c\u06f9- \u062f\u0633\u062a\u0648\u0631 Upsert<\/span><\/strong>
\n\u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc SQL \u06a9\u0647 \u062f\u0631 \u062d\u0642\u06cc\u0642\u062a \u062a\u0631\u06a9\u06cc\u0628\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0627\u0636\u0627\u0641\u0647 \u0648 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0627\u0633\u062a\u060c Upsert \u0646\u0627\u0645 \u062f\u0627\u0631\u062f. \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062b\u0627\u0644\u060c \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u06cc \u0631\u0648\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc\u0645 \u0648 \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645 \u062a\u0646\u0647\u0627 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u0628\u0627 \u0646\u0627\u0645 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647\u200c\u0641\u0631\u062f \u0647\u0633\u062a\u06cc\u0645. \u0628\u0647 \u0628\u06cc\u0627\u0646 \u062f\u06cc\u06af\u0631\u060c \u062f\u0631 \u0646\u0638\u0631 \u0646\u062f\u0627\u0631\u06cc\u0645 \u0647\u06cc\u0686 \u062f\u0648 \u0631\u062f\u06cc\u0641\u06cc \u0646\u0627\u0645 \u06cc\u06a9\u0633\u0627\u0646 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u0627\u06af\u0631 \u0633\u0639\u06cc \u06a9\u0646\u06cc\u0645 \u0686\u0646\u062f \u0645\u0642\u062f\u0627\u0631 \u0628\u0627 \u0646\u0627\u0645 Joe \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u0645\u060c \u0628\u0627\u0646\u06a9\u200c\u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u067e\u06cc\u063a\u0627\u0645 \u062e\u0637\u0627\u06cc\u06cc \u062a\u0648\u0644\u06cc\u062f \u06a9\u0631\u062f\u0647 \u0648 \u0627\u062c\u0627\u0632\u0647 \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646\u200c\u06a9\u0627\u0631 \u0631\u0627 \u0646\u0645\u06cc\u200c\u062f\u0647\u062f. \u062f\u0633\u062a\u0648\u0631 UPSERT \u0627\u062c\u0627\u0632\u0647 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0631 \u0634\u0631\u0627\u06cc\u0637\u06cc \u06a9\u0647 \u0631\u06a9\u0648\u0631\u062f \u0627\u0632 \u0642\u0628\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0627\u06af\u0631 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0631\u062f\u06cc\u0645 \u06a9\u0647 \u0631\u06a9\u0648\u0631\u062f \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06cc\u0627 \u062e\u06cc\u0631 \u0648 \u0627\u06af\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 insert \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647 \u06cc\u0627 \u0627\u0632 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0648 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0631\u062f\u06cc\u0645. \u062f\u0633\u062a\u0648\u0631 Upsert \u062f\u0631 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f. \u0631\u0648\u0634 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u062f\u0631 \u0632\u0628\u0627\u0646 MySQL \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
INSERT INTO people(name, age) VALUES('Joe', 101) ON DUPLICATE KEY UPDATE age = 101;<\/pre>\n
\u200c\u0647\u0645\u0627\u0646\u200c\u06af\u0648\u0646\u0647 \u06a9\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0645\u062d\u0627\u0648\u0631\u0647 \u0628\u0627\u0644\u0627 \u062f\u0648 \u062f\u0633\u062a\u0648\u0631 update \u0648 insert \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u0627\u0639\u0644\u0627\u0645 \u0645\u06cc\u200c\u062f\u0627\u0631\u062f \u0627\u06af\u0631 \u0642\u0627\u062f\u0631 \u0628\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0646\u06cc\u0633\u062a\u06cc\u060c \u0622\u0646\u200c\u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632 \u06a9\u0646.<\/span><\/p>\n
\u06f1\u06f0- \u062f\u0633\u062a\u0648\u0631 DELETE<\/span><\/strong>
\n\u200c\u062f\u0633\u062a\u0648\u0631 DELETE \u0631\u06a9\u0648\u0631\u062f \u06cc\u0627 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
DELETE FROM people;<\/pre>\n
\u200c\u0628\u0631\u0627\u06cc \u0622\u0646\u200c\u06a9\u0647 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u062a\u0645\u0627\u0645\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0631\u0627 \u067e\u0627\u06a9 \u0646\u06a9\u0646\u062f \u0628\u0627\u06cc\u062f \u0627\u0632 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062e\u0627\u0635 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u06a9\u0644\u06cc\u062f\u0648\u0627\u0698\u0647 WHERE \u062f\u0631 \u0627\u0646\u062a\u0647\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/span><\/p>\n
DELETE FROM people WHERE name = 'Joe';<\/pre>\n
\u200c\u200c\u06f1\u06f1- \u062f\u0633\u062a\u0648\u0631 Create Table<\/span><\/strong>
\n\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u062c\u062f\u0627\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0622\u0646 \u0633\u0627\u062f\u0647 \u0648 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
CREATE TABLE people (name TEXT, age, INTEGER, PRIMARY KEY(name));<\/pre>\n
\u200c\u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 Create Table \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0627\u0633\u062a \u06a9\u0647 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648 \u0642\u06cc\u062f\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637\u0647 \u062f\u0631 \u067e\u0631\u0627\u0646\u062a\u0632 \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f \u0648 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647\u200c \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u0627\u0646\u062a\u0647\u0627\u06cc \u062f\u0633\u062a\u0648\u0631 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n
\u06f1\u06f2- \u062f\u0633\u062a\u0648\u0631 ALTER TABLE<\/span><\/strong>
\n\u200c\u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0631 \u0633\u0627\u062e\u062a\u0627\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0627 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u200c\u0647\u0627\u06cc\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f\u060c \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062b\u0627\u0644 \u0627\u06af\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u0633\u0627\u062e\u062a\u0627\u0631 \u0628\u0627\u0639\u062b \u0634\u0648\u062f \u062a\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u062a\u062f\u0627\u062e\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u0646\u062f\u060c \u0628\u0627\u0646\u06a9\u200c\u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u062c\u0627\u0632\u0647 \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646\u200c\u06a9\u0627\u0631 \u0631\u0627 \u0646\u0645\u06cc\u200c\u062f\u0647\u062f. \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062b\u0627\u0644\u060c \u0627\u0645\u06a9\u0627\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u06cc\u06a9 \u0646\u0648\u0639 \u0631\u0634\u062a\u0647\u200c\u0627\u06cc \u0628\u0647 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f \u0635\u062d\u06cc\u062d \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0648 \u0633\u067e\u0633 \u062c\u062f\u0648\u0644 \u0627\u0635\u0637\u0644\u0627\u062d \u0634\u0648\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u0628\u0647\u200c\u06a9\u0627\u0631\u06af\u06cc\u0631\u06cc \u0641\u0631\u0645\u0627\u0646 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
ALTER TABLE people ADD height integer;<\/pre>\n
\u200c\u062f\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627 \u0633\u062a\u0648\u0646\u06cc \u0628\u0647\u200c\u0646\u0627\u0645 height \u0627\u0632 \u0646\u0648\u0639 \u0645\u0642\u062f\u0627\u0631 \u0635\u062d\u06cc\u062d (integer) \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n
\u06f1\u06f3- \u062f\u0633\u062a\u0648\u0631 DROP TABLE<\/span><\/strong>
\n\u200c\u062f\u0633\u062a\u0648\u0631 DROP TABLE \u0628\u0631\u0627\u06cc \u067e\u0627\u06a9 \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0631\u0639\u06a9\u0633 \u062f\u0633\u062a\u0648\u0631 DELETE \u06a9\u0647 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0631\u0627 \u067e\u0627\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u062a\u0645\u0627\u0645\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062f\u0631\u0648\u0646 \u0622\u0646 \u067e\u0627\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062a\u0631\u06a9\u06cc\u0628 \u0646\u062d\u0648\u06cc \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n
DROP TABLE people;<\/pre>\n
\u200c\u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062e\u0637\u0631\u0646\u0627\u06a9 \u0628\u0648\u062f\u0646 \u062f\u0633\u062a\u0648\u0631 \u0641\u0648\u0642\u060c \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u0628\u0627 \u0627\u062d\u062a\u06cc\u0627\u0637 \u06a9\u0627\u0645\u0644 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
\u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0648\u0644\u0641\u0647\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0647\u0633\u062a\u0646\u062f. \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062f\u0633\u06a9\u062a\u0627\u067e\u06cc\u060c \u0648\u0628\u200c\u0645\u062d\u0648\u0631 \u0648 \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0632\u0645\u0627\u0646\u06cc\u200c\u06a9\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0633\u0627\u062e\u062a\u200c\u06cc\u0627\u0641\u062a\u0647 (SQL) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0633\u0647\u0648\u0644\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u0648 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc \u0628\u0627\u0644\u0642\u0648\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f. \u0628\u0627…<\/p>\n","protected":false},"author":1,"featured_media":7687,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[399,2250,6,2175],"tags":[2252,2253,109,2251],"class_list":["post-7684","post","type-post","status-publish","format-standard","has-post-thumbnail","category-399","category-2250","category-6","category-2175","tag-sql","tag-2253","tag-109","tag--sql"],"yoast_head":"\n\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mehdisalimi.ir\/?p=7684\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc\" \/>\n<meta property=\"og:description\" content=\"\u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0648\u0644\u0641\u0647\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0647\u0633\u062a\u0646\u062f. \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062f\u0633\u06a9\u062a\u0627\u067e\u06cc\u060c \u0648\u0628\u200c\u0645\u062d\u0648\u0631 \u0648 \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0632\u0645\u0627\u0646\u06cc\u200c\u06a9\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0633\u0627\u062e\u062a\u200c\u06cc\u0627\u0641\u062a\u0647 (SQL) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0633\u0647\u0648\u0644\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u0648 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc \u0628\u0627\u0644\u0642\u0648\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f. \u0628\u0627…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mehdisalimi.ir\/?p=7684\" \/>\n<meta property=\"og:site_name\" content=\"\u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/mehdisalimi13\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/mehdisalimi13\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-28T11:01:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-28T12:08:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"263\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mehd!Salimi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/mehdisalimi13\" \/>\n<meta name=\"twitter:site\" content=\"@mehdisalimi13\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mehd!Salimi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684\"},\"author\":{\"name\":\"Mehd!Salimi\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#\\\/schema\\\/person\\\/aa4ebf7fb5115362f325b292af001e65\"},\"headline\":\"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL\",\"datePublished\":\"2021-01-28T11:01:31+00:00\",\"dateModified\":\"2021-01-28T12:08:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684\"},\"wordCount\":140,\"publisher\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#\\\/schema\\\/person\\\/aa4ebf7fb5115362f325b292af001e65\"},\"image\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/SQL.jpg\",\"keywords\":[\"SQL\",\"\u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc\",\"\u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc\",\"\u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\",\"\u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc\",\"\u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc\",\"\u0645\u062c\u0644\u0647 \u0641\u0646\u0627\u0648\u0631\u06cc\"],\"inLanguage\":\"fa-IR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684\",\"url\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684\",\"name\":\"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/SQL.jpg\",\"datePublished\":\"2021-01-28T11:01:31+00:00\",\"dateModified\":\"2021-01-28T12:08:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#primaryimage\",\"url\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/SQL.jpg\",\"contentUrl\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/SQL.jpg\",\"width\":580,\"height\":263},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/?p=7684#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\\\/\\\/mehdisalimi.ir\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#website\",\"url\":\"https:\\\/\\\/mehdisalimi.ir\\\/\",\"name\":\"\u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc\",\"description\":\"[\u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0648 \u0647\u0631 \u0627\u0632 \u06af\u0627\u0647\u06cc \u0686\u0646\u062f \u062e\u0637 \u06a9\u062f]\",\"publisher\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#\\\/schema\\\/person\\\/aa4ebf7fb5115362f325b292af001e65\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mehdisalimi.ir\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/#\\\/schema\\\/person\\\/aa4ebf7fb5115362f325b292af001e65\",\"name\":\"Mehd!Salimi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/llog2.png\",\"url\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/llog2.png\",\"contentUrl\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/llog2.png\",\"width\":450,\"height\":180,\"caption\":\"Mehd!Salimi\"},\"logo\":{\"@id\":\"https:\\\/\\\/mehdisalimi.ir\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/llog2.png\"},\"sameAs\":[\"http:\\\/\\\/www.mehdisalimi.ir\",\"https:\\\/\\\/www.facebook.com\\\/mehdisalimi13\",\"https:\\\/\\\/ir.linkedin.com\\\/in\\\/mehdisalimi13\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/mehdisalimi13\"],\"url\":\"https:\\\/\\\/mehdisalimi.ir\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mehdisalimi.ir\/?p=7684","og_locale":"fa_IR","og_type":"article","og_title":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc","og_description":"\u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06cc\u06a9\u06cc \u0627\u0632 \u0645\u0648\u0644\u0641\u0647\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0647\u0633\u062a\u0646\u062f. \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062f\u0633\u06a9\u062a\u0627\u067e\u06cc\u060c \u0648\u0628\u200c\u0645\u062d\u0648\u0631 \u0648 \u0648\u0628\u200c\u0633\u0627\u06cc\u062a\u200c\u0647\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0632\u0645\u0627\u0646\u06cc\u200c\u06a9\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062f\u0631 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0645\u062d\u0627\u0648\u0631\u0647 \u0633\u0627\u062e\u062a\u200c\u06cc\u0627\u0641\u062a\u0647 (SQL) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0633\u0647\u0648\u0644\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u0648 \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc \u0628\u0627\u0644\u0642\u0648\u0647 \u0628\u0627\u0646\u06a9\u200c\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f. \u0628\u0627…","og_url":"https:\/\/mehdisalimi.ir\/?p=7684","og_site_name":"\u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc","article_publisher":"https:\/\/www.facebook.com\/mehdisalimi13","article_author":"https:\/\/www.facebook.com\/mehdisalimi13","article_published_time":"2021-01-28T11:01:31+00:00","article_modified_time":"2021-01-28T12:08:56+00:00","og_image":[{"width":580,"height":263,"url":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg","type":"image\/jpeg"}],"author":"Mehd!Salimi","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/mehdisalimi13","twitter_site":"@mehdisalimi13","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"Mehd!Salimi","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"2 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mehdisalimi.ir\/?p=7684#article","isPartOf":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684"},"author":{"name":"Mehd!Salimi","@id":"https:\/\/mehdisalimi.ir\/#\/schema\/person\/aa4ebf7fb5115362f325b292af001e65"},"headline":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL","datePublished":"2021-01-28T11:01:31+00:00","dateModified":"2021-01-28T12:08:56+00:00","mainEntityOfPage":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684"},"wordCount":140,"publisher":{"@id":"https:\/\/mehdisalimi.ir\/#\/schema\/person\/aa4ebf7fb5115362f325b292af001e65"},"image":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684#primaryimage"},"thumbnailUrl":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg","keywords":["SQL","\u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc","\u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc","\u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL"],"articleSection":["\u0622\u0645\u0648\u0632\u0634","\u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc","\u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc","\u0645\u062c\u0644\u0647 \u0641\u0646\u0627\u0648\u0631\u06cc"],"inLanguage":"fa-IR"},{"@type":"WebPage","@id":"https:\/\/mehdisalimi.ir\/?p=7684","url":"https:\/\/mehdisalimi.ir\/?p=7684","name":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL - \u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc","isPartOf":{"@id":"https:\/\/mehdisalimi.ir\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684#primaryimage"},"image":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684#primaryimage"},"thumbnailUrl":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg","datePublished":"2021-01-28T11:01:31+00:00","dateModified":"2021-01-28T12:08:56+00:00","breadcrumb":{"@id":"https:\/\/mehdisalimi.ir\/?p=7684#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mehdisalimi.ir\/?p=7684"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/mehdisalimi.ir\/?p=7684#primaryimage","url":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg","contentUrl":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2021\/01\/SQL.jpg","width":580,"height":263},{"@type":"BreadcrumbList","@id":"https:\/\/mehdisalimi.ir\/?p=7684#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/mehdisalimi.ir\/"},{"@type":"ListItem","position":2,"name":"\u200c\u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL"}]},{"@type":"WebSite","@id":"https:\/\/mehdisalimi.ir\/#website","url":"https:\/\/mehdisalimi.ir\/","name":"\u0633\u06cc\u062f \u0645\u0647\u062f\u06cc \u0633\u0644\u06cc\u0645\u06cc","description":"[\u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0648 \u0647\u0631 \u0627\u0632 \u06af\u0627\u0647\u06cc \u0686\u0646\u062f \u062e\u0637 \u06a9\u062f]","publisher":{"@id":"https:\/\/mehdisalimi.ir\/#\/schema\/person\/aa4ebf7fb5115362f325b292af001e65"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mehdisalimi.ir\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":["Person","Organization"],"@id":"https:\/\/mehdisalimi.ir\/#\/schema\/person\/aa4ebf7fb5115362f325b292af001e65","name":"Mehd!Salimi","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2020\/04\/llog2.png","url":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2020\/04\/llog2.png","contentUrl":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2020\/04\/llog2.png","width":450,"height":180,"caption":"Mehd!Salimi"},"logo":{"@id":"https:\/\/mehdisalimi.ir\/wp-content\/uploads\/2020\/04\/llog2.png"},"sameAs":["http:\/\/www.mehdisalimi.ir","https:\/\/www.facebook.com\/mehdisalimi13","https:\/\/ir.linkedin.com\/in\/mehdisalimi13","https:\/\/x.com\/https:\/\/twitter.com\/mehdisalimi13"],"url":"https:\/\/mehdisalimi.ir\/?author=1"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/posts\/7684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7684"}],"version-history":[{"count":5,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/posts\/7684\/revisions"}],"predecessor-version":[{"id":7704,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/posts\/7684\/revisions\/7704"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=\/wp\/v2\/media\/7687"}],"wp:attachment":[{"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mehdisalimi.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}