{"id":6298,"date":"2026-05-03T11:00:56","date_gmt":"2026-05-03T07:30:56","guid":{"rendered":"https:\/\/parmin.cloud\/blog\/?p=6298"},"modified":"2026-05-03T11:01:05","modified_gmt":"2026-05-03T07:31:05","slug":"%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a8%d9%87%d8%b1%d9%88%d8%b2%d8%b1%d8%b3%d8%a7%d9%86%db%8c-%d8%af%d8%a7%d8%af%d9%87%d9%87%d8%a7-%d8%af%d8%b1-sql","status":"publish","type":"post","link":"https:\/\/parmin.cloud\/blog\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a8%d9%87%d8%b1%d9%88%d8%b2%d8%b1%d8%b3%d8%a7%d9%86%db%8c-%d8%af%d8%a7%d8%af%d9%87%d9%87%d8%a7-%d8%af%d8%b1-sql\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 SQL"},"content":{"rendered":"

\u0645\u0642\u062f\u0645\u0647<\/h4>\n

\u0648\u0642\u062a\u06cc \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u06af\u0627\u0647\u06cc \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0642\u0628\u0644\u0627\u064b \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f. \u0645\u062b\u0644\u0627\u064b \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u06cc\u06a9 \u0627\u0634\u062a\u0628\u0627\u0647 \u062a\u0627\u06cc\u067e\u06cc \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062c\u062f\u06cc\u062f\u06cc \u0628\u0647 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u0646\u0627\u0642\u0635 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.
\u0632\u0628\u0627\u0646 SQL (Structured Query Language) \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 UPDATE<\/strong> \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n

\n

\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627<\/h4>\n

\u0628\u0631\u0627\u06cc \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634\u060c \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 (RDBMS) \u0645\u062b\u0644 MySQL \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.
\u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0646\u0645\u0648\u0646\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0631\u0627 \u062a\u0645\u0631\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n

\n

\u0627\u062a\u0635\u0627\u0644 \u0628\u0647 MySQL \u0648 \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0646\u0645\u0648\u0646\u0647<\/h4>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
CREATE<\/span> DATABASE updateDB;\r\nUSE updateDB;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644\u200c\u0647\u0627<\/h4>\n
\u062c\u062f\u0648\u0644 clients:<\/strong><\/p>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
CREATE<\/span> TABLE<\/span> clients (\r\nclientID int<\/span> PRIMARY<\/span> KEY<\/span>,\r\nname varchar<\/span>(20<\/span>),\r\nroutine<\/span> varchar<\/span>(30<\/span>),\r\nstandardFee decimal<\/span> (5<\/span>,2<\/span>)\r\n);<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\u062c\u062f\u0648\u0644 shows:<\/strong><\/p>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
CREATE<\/span> TABLE<\/span> shows (\r\nshowID int<\/span> PRIMARY<\/span> KEY<\/span>,\r\nshowDate date<\/span>,\r\nclientID int<\/span>,\r\nattendance int<\/span>,\r\nticketPrice decimal<\/span> (4<\/span>,2<\/span>),\r\nCONSTRAINT<\/span> client_fk\r\nFOREIGN<\/span> KEY<\/span> (clientID)\r\nREFERENCES<\/span> clients(clientID)\r\n);<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647 \u0646\u0645\u0648\u0646\u0647<\/h4>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
INSERT<\/span> INTO<\/span> clients VALUES<\/span>\r\n(1<\/span>, 'Gladys'<\/span>, 'song and dance'<\/span>, 180<\/span>),\r\n(2<\/span>, 'Catherine'<\/span>, 'standup'<\/span>, 99.99<\/span>),\r\n(3<\/span>, 'Georgeanna'<\/span>, 'standup'<\/span>, 45<\/span>),\r\n(4<\/span>, 'Wanda'<\/span>, 'song and dance'<\/span>, 200<\/span>),\r\n(5<\/span>, 'Ann'<\/span>, 'trained squirrel'<\/span>, 79.99<\/span>);<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
INSERT<\/span> INTO<\/span> shows VALUES<\/span>\r\n(1<\/span>, '2019-12-25'<\/span>, 4<\/span>, 124<\/span>, 15<\/span>),\r\n(2<\/span>, '2020-01-11'<\/span>, 5<\/span>, 84<\/span>, 29.50<\/span>),\r\n(3<\/span>, '2020-01-17'<\/span>, 3<\/span>, 170<\/span>, 12.99<\/span>),\r\n(4<\/span>, '2020-01-31'<\/span>, 5<\/span>, 234<\/span>, 14.99<\/span>),\r\n(5<\/span>, '2020-02-08'<\/span>, 1<\/span>, 86<\/span>, 25<\/span>);<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644<\/h2>\n
\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc:<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> table_name\r\nSET<\/span> column_name =<\/span> value<\/span>\r\nWHERE<\/span> condition<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\u26a0\ufe0f \u0627\u06af\u0631 WHERE \u0646\u0646\u0648\u06cc\u0633\u06cc\u062f\u060c \u0647\u0645\u0647\u200c\u06cc \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<\/p>\n
\n
\u0645\u062b\u0627\u0644 1: \u0627\u0635\u0644\u0627\u062d \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients\r\nSET<\/span> name =<\/span> 'Katherine'<\/span>\r\nWHERE<\/span> name =<\/span> 'Catherine'<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0645\u062b\u0627\u0644 2: \u0622\u067e\u062f\u06cc\u062a \u0686\u0646\u062f \u0631\u062f\u06cc\u0641<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients\r\nSET<\/span> standardFee =<\/span> 140<\/span>\r\nWHERE<\/span> routine<\/span> LIKE<\/span> 's%'<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0645\u062b\u0627\u0644 3: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0645\u0644\u06cc\u0627\u062a \u0631\u06cc\u0627\u0636\u06cc<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients\r\nSET<\/span> standardFee =<\/span> standardFee *<\/span> 1.4<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0622\u067e\u062f\u06cc\u062a \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0647\u0645\u0632\u0645\u0627\u0646<\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> shows\r\nSET<\/span> attendance =<\/span> attendance +<\/span> 20<\/span>,\r\nticketPrice =<\/span> ticketPrice *<\/span> 1.5<\/span>\r\nWHERE<\/span> clientID IN<\/span> (\r\nSELECT<\/span> clientID\r\nFROM<\/span> clients\r\nWHERE<\/span> name =<\/span> 'Georgeanna'<\/span> OR<\/span> name =<\/span> 'Wanda'<\/span>\r\n);<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0622\u067e\u062f\u06cc\u062a \u0628\u0627 JOIN (\u0686\u0646\u062f \u062c\u062f\u0648\u0644)<\/h2>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients JOIN<\/span> shows\r\nUSING<\/span> (clientID)\r\nSET<\/span> clients.routine =<\/span> 'mime'<\/span>,\r\nshows.ticketPrice =<\/span> 30<\/span>\r\nWHERE<\/span> name =<\/span> 'Gladys'<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0645\u062f\u06cc\u0631\u06cc\u062a Foreign Key \u062f\u0631 UPDATE<\/h2>\n
\u062d\u0627\u0644\u062a \u067e\u06cc\u0634\u200c\u0641\u0631\u0636:<\/h3>\n
\u0627\u06af\u0631 \u0622\u067e\u062f\u06cc\u062a \u0628\u0627\u0639\u062b \u0646\u0642\u0636 Foreign Key \u0634\u0648\u062f\u060c \u062e\u0637\u0627 \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients\r\nSET<\/span> clientID =<\/span> 9<\/span>\r\nWHERE<\/span> name =<\/span> 'Ann'<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u0631\u0627\u0647\u200c\u062d\u0644: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 ON UPDATE CASCADE<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
ALTER<\/span> TABLE<\/span> shows\r\nDROP<\/span> FOREIGN<\/span> KEY<\/span> client_fk;\r\n\r\nALTER<\/span> TABLE<\/span> shows\r\nADD<\/span> CONSTRAINT<\/span> new_client_fk\r\nFOREIGN<\/span> KEY<\/span> (clientID)\r\nREFERENCES<\/span> clients (clientID)\r\nON<\/span> UPDATE<\/span> CASCADE<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u062d\u0627\u0644\u0627 \u0622\u067e\u062f\u06cc\u062a \u0628\u062f\u0648\u0646 \u062e\u0637\u0627:<\/h3>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
UPDATE<\/span> clients\r\nSET<\/span> clientID =<\/span> 9<\/span>\r\nWHERE<\/span> name =<\/span> 'Ann'<\/span>;<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\u2714 \u0627\u06cc\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0647 \u062c\u062f\u0648\u0644 shows \u0647\u0645 \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n
\n
\u062c\u0645\u0639\u200c\u0628\u0646\u062f\u06cc<\/h2>\n