\u062f\u0631 Structured Query Language<\/strong> \u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0646\u0627\u0645 SQL<\/strong> \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u062f\u0633\u062a\u0648\u0631 DELETE<\/strong> \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a\u200c\u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f. \u0647\u0645\u0627\u0646\u200c\u0637\u0648\u0631 \u06a9\u0647 \u0627\u0632 \u0646\u0627\u0645 \u0622\u0646 \u067e\u06cc\u062f\u0627\u0633\u062a\u060c \u0639\u0645\u0644\u06cc\u0627\u062a DELETE \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u063a\u06cc\u0631\u0642\u0627\u0628\u0644 \u0628\u0627\u0632\u06af\u0634\u062a<\/strong> \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 (Row) \u062f\u0627\u062f\u0647 \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n \u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 DELETE \u0628\u062e\u0634 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645\u06cc \u0627\u0632 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647 \u0645\u062d\u0633\u0648\u0628 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 SQL \u062f\u0631\u06a9 \u062f\u0642\u06cc\u0642\u06cc \u0627\u0632 \u0646\u062d\u0648\u0647\u200c\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f.<\/p>\n \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n \u0686\u06af\u0648\u0646\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u06cc\u0646\u062a\u06a9\u0633 DELETE \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u062c\u062f\u0648\u0644 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n SQL \u0686\u06af\u0648\u0646\u0647 \u0628\u0627 \u0639\u0645\u0644\u06cc\u0627\u062a DELETE \u06a9\u0647 \u0628\u0627 Foreign Key Constraint<\/strong> \u062f\u0631 \u062a\u0636\u0627\u062f \u0647\u0633\u062a\u0646\u062f \u0628\u0631\u062e\u0648\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f<\/p>\n<\/li>\n<\/ul>\n \u0628\u0631\u0627\u06cc \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f:<\/p>\n \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u062f\u0627\u0631\u0627\u06cc Relational Database Management System (RDBMS)<\/strong> \u06a9\u0647 \u0627\u0632 SQL \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u06a9\u0646\u062f<\/p>\n<\/li>\n<\/ul>\n \u0646\u0645\u0648\u0646\u0647\u200c\u0647\u0627 \u0648 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0632\u06cc\u0631 \u0628\u0631\u0631\u0633\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f:<\/p>\n \u0633\u0631\u0648\u0631 Ubuntu 20.04 \u0628\u0627 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 non-root \u062f\u0627\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0648 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 UFW<\/p>\n<\/li>\n MySQL \u0646\u0635\u0628 \u0648 \u0627\u06cc\u0645\u0646\u200c\u0633\u0627\u0632\u06cc\u200c\u0634\u062f\u0647 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631<\/p>\n<\/li>\n \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 non-root \u062f\u0631 MySQL<\/p>\n<\/li>\n<\/ul>\n \u062a\u0648\u062c\u0647: \u0647\u0631 RDBMS \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u062e\u0635\u0648\u0635 \u062e\u0648\u062f \u0627\u0632 SQL \u0631\u0627 \u062f\u0627\u0631\u062f. \u0627\u06af\u0631\u0686\u0647 \u0628\u06cc\u0634\u062a\u0631 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0631 \u0627\u06a9\u062b\u0631 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f\u060c \u0627\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0633\u06cc\u0646\u062a\u06a9\u0633 \u06cc\u0627 \u062e\u0631\u0648\u062c\u06cc \u062f\u0642\u06cc\u0642 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc\u06cc \u063a\u06cc\u0631 \u0627\u0632 MySQL \u06a9\u0645\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0627\u0634\u062f.<\/p>\n<\/blockquote>\n \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0646\u0645\u0648\u0646\u0647 \u0648 \u0686\u0646\u062f \u062c\u062f\u0648\u0644 \u062f\u0627\u0631\u0627\u06cc \u062f\u0627\u062f\u0647<\/strong> \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0639\u0645\u0644\u06cc\u0627\u062a \u062d\u0630\u0641 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062a\u0645\u0631\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n \u0627\u0628\u062a\u062f\u0627 \u0628\u0647 \u0633\u0631\u0648\u0631 \u062e\u0648\u062f SSH \u0628\u0632\u0646\u06cc\u062f:<\/p>\n \u0633\u067e\u0633 \u0648\u0627\u0631\u062f \u0645\u062d\u06cc\u0637 MySQL \u0634\u0648\u06cc\u062f:<\/p>\n \u062e\u0631\u0648\u062c\u06cc \u0645\u0648\u0641\u0642:<\/p>\n \u0627\u0646\u062a\u062e\u0627\u0628 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633:<\/p>\n \u0647\u0634\u062f\u0627\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645:<\/strong> \u0627\u0628\u062a\u062f\u0627 \u0628\u0631\u0631\u0633\u06cc \u0628\u0627 SELECT:<\/p>\n \u0633\u067e\u0633 \u062d\u0630\u0641:<\/p>\n\n
\n\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627 (Prerequisites)<\/h2>\n
\n
\n
\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<\/h2>\n
ssh sammy@your_server_ip
\n<\/code><\/div>\n<\/div>\nmysql -u sammy -p
\n<\/code><\/div>\n<\/div>\n\u0627\u06cc\u062c\u0627\u062f \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/h3>\n
CREATE<\/span> DATABASE deleteDB;
\n<\/code><\/div>\n<\/div>\nQuery<\/span> OK, 1<\/span> row affected (<\/span>0.01<\/span> sec)<\/span>
\n<\/code><\/div>\n<\/div>\nUSE deleteDB;
\n<\/code><\/div>\n<\/div>\n
\n\u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644\u200c\u0647\u0627<\/h2>\n
\u062c\u062f\u0648\u0644 \u0627\u0639\u0636\u0627\u06cc \u0628\u0627\u0634\u06af\u0627\u0647 (clubMembers)<\/h3>\n
CREATE TABLE<\/span> clubMembers (
\nmemberID int<\/span> PRIMARY KEY<\/span>,
\nname varchar<\/span>(30<\/span>),
\nhomeBorough varchar<\/span>(15<\/span>),
\nemail varchar<\/span>(30<\/span>)
\n);
\n<\/code><\/div>\n<\/div>\n\u062c\u062f\u0648\u0644 \u062a\u062c\u0647\u06cc\u0632\u0627\u062a (clubEquipment) \u0628\u0627 Foreign Key<\/h3>\n
CREATE TABLE<\/span> clubEquipment (
\nequipmentID int<\/span> PRIMARY KEY<\/span>,
\nequipmentType varchar<\/span>(30<\/span>),
\nbrand varchar<\/span>(15<\/span>),
\nownerID int<\/span>,
\nCONSTRAINT<\/span> fk_ownerID
\nFOREIGN KEY<\/span> (ownerID) REFERENCES<\/span> clubMembers(memberID)
\n);
\n<\/code><\/div>\n<\/div>\n
\n\u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0646\u0645\u0648\u0646\u0647<\/h2>\n
\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0627\u0639\u0636\u0627:<\/h3>\n
INSERT INTO<\/span> clubMembers VALUES<\/span>
\n(1<\/span>, 'Rosetta'<\/span>, 'Manhattan'<\/span>, 'hightower@example.com'<\/span>),
\n(2<\/span>, 'Linda'<\/span>, 'Staten Island'<\/span>, 'lyndell@example.com'<\/span>),
\n(3<\/span>, 'Labi'<\/span>, 'Brooklyn'<\/span>, 'siffre@example.com'<\/span>),
\n(4<\/span>, 'Bettye'<\/span>, 'Queens'<\/span>, 'lavette@example.com'<\/span>),
\n(5<\/span>, 'Phoebe'<\/span>, 'Bronx'<\/span>, 'snow@example.com'<\/span>),
\n(6<\/span>, 'Mariya'<\/span>, 'Brooklyn'<\/span>, 'takeuchi@example.com'<\/span>);
\n<\/code><\/div>\n<\/div>\n\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u062c\u0647\u06cc\u0632\u0627\u062a:<\/h3>\n
INSERT INTO<\/span> clubEquipment VALUES<\/span>
\n(1<\/span>, 'electric guitar'<\/span>, 'Gilled'<\/span>, 6<\/span>),
\n(2<\/span>, 'trumpet'<\/span>, 'Yemehe'<\/span>, 5<\/span>),
\n(3<\/span>, 'drum kit'<\/span>, 'Purl'<\/span>, 3<\/span>),
\n(4<\/span>, 'mixer'<\/span>, 'Bearinger'<\/span>, 3<\/span>),
\n(5<\/span>, 'microphone'<\/span>, 'Sure'<\/span>, 1<\/span>),
\n(6<\/span>, 'bass guitar'<\/span>, 'Fandar'<\/span>, 4<\/span>),
\n(7<\/span>, 'acoustic guitar'<\/span>, 'Marten'<\/span>, 6<\/span>),
\n(8<\/span>, 'synthesizer'<\/span>, 'Korgi'<\/span>, 4<\/span>),
\n(9<\/span>, 'guitar amplifier'<\/span>, 'Vax'<\/span>, 4<\/span>),
\n(10<\/span>, 'keytar'<\/span>, 'Poland'<\/span>, 3<\/span>),
\n(11<\/span>, 'acoustic\/electric bass'<\/span>, 'Pepiphone'<\/span>, 2<\/span>),
\n(12<\/span>, 'trombone'<\/span>, 'Cann'<\/span>, 2<\/span>),
\n(13<\/span>, 'mandolin'<\/span>, 'Rouge'<\/span>, 1<\/span>),
\n(14<\/span>, 'electric guitar'<\/span>, 'Vax'<\/span>, 6<\/span>),
\n(15<\/span>, 'accordion'<\/span>, 'Nonher'<\/span>, 5<\/span>),
\n(16<\/span>, 'electric organ'<\/span>, 'Spammond'<\/span>, 1<\/span>),
\n(17<\/span>, 'bass guitar'<\/span>, 'Peabey'<\/span>, 1<\/span>),
\n(18<\/span>, 'guitar amplifier'<\/span>, 'Fandar'<\/span>, 3<\/span>),
\n(19<\/span>, 'cello'<\/span>, 'Yemehe'<\/span>, 2<\/span>),
\n(20<\/span>, 'PA system'<\/span>, 'Mockville'<\/span>, 5<\/span>);
\n<\/code><\/div>\n<\/div>\n
\n\u062d\u0630\u0641 \u062f\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 (Deleting Data from a Single Table)<\/h2>\n
\u0633\u06cc\u0646\u062a\u06a9\u0633 \u06a9\u0644\u06cc DELETE<\/h3>\n
DELETE<\/span> FROM<\/span> table_name
\nWHERE<\/span> conditions_apply;
\n<\/code><\/div>\n<\/div>\n
\u0627\u06af\u0631 \u0634\u0631\u0637 WHERE<\/code> \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u060c \u062a\u0645\u0627\u0645 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u062d\u0630\u0641 \u062e\u0648\u0627\u0647\u0646\u062f \u0634\u062f<\/strong>.<\/p>\n
\n\u0645\u062b\u0627\u0644: \u062d\u0630\u0641 \u062a\u062c\u0647\u06cc\u0632\u0627\u062a \u0628\u0631\u0646\u062f Korgi<\/h3>\n
SELECT<\/span> *<\/span> FROM<\/span> clubEquipment
\nWHERE<\/span> brand =<\/span> 'Korgi'<\/span>;
\n<\/code><\/div>\n<\/div>\nDELETE<\/span> FROM<\/span> clubEquipment
\nWHERE<\/span> brand =<\/span> 'Korgi'<\/span>;
\n<\/code><\/div>\n<\/div>\n
\n\u062d\u0630\u0641 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u0647\u0645\u200c\u0632\u0645\u0627\u0646<\/h3>\n