{"id":3392,"date":"2016-07-25T08:20:49","date_gmt":"2016-07-25T08:20:49","guid":{"rendered":"https:\/\/kiencang.net\/?p=3392"},"modified":"2016-07-25T08:20:49","modified_gmt":"2016-07-25T08:20:49","slug":"cau-lenh-delete-trong-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/","title":{"rendered":"C\u00e2u l\u1ec7nh DELETE trong SQL"},"content":{"rendered":"\n

C\u00e2u l\u1ec7nh DELETE<\/code> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 xo\u00e1 c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng.<\/p>\n\n\n\n

C\u00fa ph\u00e1p c\u1ee7a SQL<\/a> DELETE<\/code>:<\/p>\n\n\n\n

DELETE FROM ten_bang\nWHERE mot_so_cot=mot_so_gia_tri;<\/code><\/pre>\n\n\n\n
L\u01b0u \u00fd m\u1ec7nh \u0111\u1ec1 WHERE trong c\u00e2u l\u1ec7nh SQL DELETE <\/strong><\/p>\n\n\n\n
M\u1ec7nh \u0111\u1ec1 WHERE<\/code> ch\u1ec9 \u0111\u1ecbnh b\u1ea3n ghi ho\u1eb7c c\u00e1c b\u1ea3n ghi ph\u1ea3i \u0111\u01b0\u1ee3c xo\u00e1. N\u1ebfu b\u1ea1n b\u1ecf qua m\u1ec7nh \u0111\u1ec1 WHERE<\/code>, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi s\u1ebd b\u1ecb xo\u00e1!<\/p>\n\n\n\n
\n\n\n\n
C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo<\/h2>\n\n\n\n
Trong kho\u00e1 n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn.<\/p>\n\n\n\n
D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”:<\/p>\n\n\n\n
CustomerID<\/th>CustomerName<\/th>ContactName<\/th>Address<\/th>City<\/th>PostalCode<\/th>Country<\/th><\/tr>
1<\/td>Alfreds Futterkiste<\/td>Maria Anders<\/td>Obere Str. 57<\/td>Berlin<\/td>12209<\/td>Germany<\/td><\/tr>
2<\/td>Ana Trujillo Emparedados y helados<\/td>Ana Trujillo<\/td>Avda. de la Constituci\u00f3n 2222<\/td>M\u00e9xico D.F.<\/td>05021<\/td>Mexico<\/td><\/tr>
3<\/td>Antonio Moreno Taquer\u00eda<\/td>Antonio Moreno<\/td>Mataderos 2312<\/td>M\u00e9xico D.F.<\/td>05023<\/td>Mexico<\/td><\/tr>
4<\/td>Around the Horn<\/td>Thomas Hardy<\/td>120 Hanover Sq.<\/td>London<\/td>WA1 1DP<\/td>UK<\/td><\/tr>
5<\/td>Berglunds snabbk\u00f6p<\/td>Christina Berglund<\/td>Berguvsv\u00e4gen 8<\/td>Lule\u00e5<\/td>S-958 22<\/td>Sweden<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
V\u00ed d\u1ee5 v\u1ec1 SQL DELETE<\/h2>\n\n\n\n
Gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n xo\u00e1 kh\u00e1ch h\u00e0ng “Alfreds Futterkiste” t\u1eeb b\u1ea3ng “Customers”.<\/p>\n\n\n\n
Ch\u00fang ta s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL sau:<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/p>\n\n\n\n
DELETE FROM Customers\nWHERE CustomerName='Alfreds Futterkiste' AND ContactName='Maria Anders';<\/code><\/pre>\n\n\n\n
B\u1ea3ng “Customers” gi\u1edd s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n
CustomerID<\/th>CustomerName<\/th>ContactName<\/th>Address<\/th>City<\/th>PostalCode<\/th>Country<\/th><\/tr>
2<\/td>Ana Trujillo Emparedados y helados<\/td>Ana Trujillo<\/td>Avda. de la Constituci\u00f3n 2222<\/td>M\u00e9xico D.F.<\/td>05021<\/td>Mexico<\/td><\/tr>
3<\/td>Antonio Moreno Taquer\u00eda<\/td>Antonio Moreno<\/td>Mataderos 2312<\/td>M\u00e9xico D.F.<\/td>05023<\/td>Mexico<\/td><\/tr>
4<\/td>Around the Horn<\/td>Thomas Hardy<\/td>120 Hanover Sq.<\/td>London<\/td>WA1 1DP<\/td>UK<\/td><\/tr>
5<\/td>Berglunds snabbk\u00f6p<\/td>Christina Berglund<\/td>Berguvsv\u00e4gen 8<\/td>Lule\u00e5<\/td>S-958 22<\/td>Sweden<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
Xo\u00e1 t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u<\/h2>\n\n\n\n
B\u1ea1n c\u00f3 th\u1ec3 xo\u00e1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng m\u00e0 kh\u00f4ng xo\u00e1 b\u1ea3ng. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u1ea5u tr\u00fac b\u1ea3ng, c\u00e1c thu\u1ed9c t\u00ednh v\u00e0 c\u00e1c ch\u1ec9 s\u1ed1 s\u1ebd v\u1eabn c\u00f2n nguy\u00ean:<\/p>\n\n\n\n
DELETE FROM table_name;<\/code><\/pre>\n\n\n\n
ho\u1eb7c<\/p>\n\n\n\n
DELETE * FROM table_name;<\/code><\/pre>\n\n\n\n
Note:<\/b> Ph\u1ea3i c\u1ea9n th\u1eadn khi mu\u1ed1n xo\u00e1 c\u00e1c b\u1ea3n ghi. B\u1ea1n kh\u00f4ng th\u1ec3 undo (ki\u1ec3u Ctrl + Z) c\u00e2u l\u1ec7nh n\u00e0y \u0111\u00e2u! V\u00ec v\u1eady trong th\u1ef1c t\u1ebf v\u1edbi c\u00e1c d\u1eef li\u1ec7u ng\u01b0\u1eddi ta hi\u1ebfm khi xo\u00e1 m\u00e0 th\u01b0\u1eddng th\u00eam m\u1ed9t tr\u01b0\u1eddng \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u n\u00f3 c\u00f3 c\u1ea7n d\u00f9ng hay kh\u00f4ng v\u00e0 gi\u00fap l\u1ea5y l\u1ea1i d\u1eef li\u1ec7u khi c\u1ea7n thi\u1ebft ph\u1ea3i xem x\u00e9t.<\/p>\n","protected":false},"excerpt":{"rendered":"
C\u00e2u l\u1ec7nh DELETE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 xo\u00e1 c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng. C\u00fa ph\u00e1p c\u1ee7a SQL DELETE: L\u01b0u \u00fd m\u1ec7nh \u0111\u1ec1 WHERE trong c\u00e2u l\u1ec7nh SQL DELETE  M\u1ec7nh \u0111\u1ec1 WHERE ch\u1ec9 \u0111\u1ecbnh b\u1ea3n ghi ho\u1eb7c c\u00e1c b\u1ea3n ghi ph\u1ea3i \u0111\u01b0\u1ee3c xo\u00e1. N\u1ebfu b\u1ea1n b\u1ecf qua m\u1ec7nh \u0111\u1ec1 WHERE, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi s\u1ebd …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[239],"tags":[],"yoast_head":"\nC\u00e2u l\u1ec7nh DELETE trong SQL • Ki\u1ebfn c\u00e0ng<\/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:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e2u l\u1ec7nh DELETE trong SQL • Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"C\u00e2u l\u1ec7nh DELETE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 xo\u00e1 c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng. C\u00fa ph\u00e1p c\u1ee7a SQL DELETE: L\u01b0u \u00fd m\u1ec7nh \u0111\u1ec1 WHERE trong c\u00e2u l\u1ec7nh SQL DELETE  M\u1ec7nh \u0111\u1ec1 WHERE ch\u1ec9 \u0111\u1ecbnh b\u1ea3n ghi ho\u1eb7c c\u00e1c b\u1ea3n ghi ph\u1ea3i \u0111\u01b0\u1ee3c xo\u00e1. N\u1ebfu b\u1ea1n b\u1ecf qua m\u1ec7nh \u0111\u1ec1 WHERE, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi s\u1ebd …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-25T08:20:49+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e2u l\u1ec7nh DELETE trong SQL • Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e2u l\u1ec7nh DELETE trong SQL • Ki\u1ebfn c\u00e0ng","og_description":"C\u00e2u l\u1ec7nh DELETE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 xo\u00e1 c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng. C\u00fa ph\u00e1p c\u1ee7a SQL DELETE: L\u01b0u \u00fd m\u1ec7nh \u0111\u1ec1 WHERE trong c\u00e2u l\u1ec7nh SQL DELETE  M\u1ec7nh \u0111\u1ec1 WHERE ch\u1ec9 \u0111\u1ecbnh b\u1ea3n ghi ho\u1eb7c c\u00e1c b\u1ea3n ghi ph\u1ea3i \u0111\u01b0\u1ee3c xo\u00e1. N\u1ebfu b\u1ea1n b\u1ecf qua m\u1ec7nh \u0111\u1ec1 WHERE, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi s\u1ebd …","og_url":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-25T08:20:49+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/","url":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/","name":"C\u00e2u l\u1ec7nh DELETE trong SQL • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-25T08:20:49+00:00","dateModified":"2016-07-25T08:20:49+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cau-lenh-delete-trong-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e2u l\u1ec7nh DELETE trong SQL"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3392"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3392"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3392\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}