INSERT INTO<\/code> th\u00e0nh hai d\u1ea1ng.<\/p>\n\n\n\nD\u1ea1ng th\u1ee9 nh\u1ea5t kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh t\u00ean c\u1ed9t n\u01a1i d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n, ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang:<\/p>\n\n\n\n
INSERT INTO ten_bang\nVALUES (gia_tri1,gia_tri2,gia_tri3,...);<\/code><\/pre>\n\n\n\nD\u1ea1ng th\u1ee9 hai ch\u1ec9 \u0111\u1ecbnh c\u1ea3 t\u00ean c\u1ed9t v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o:<\/p>\n\n\n\n
INSERT INTO ten-bang (cot1,cot2,cot3,...)\nVALUES (gia_tri1,gia_tri2,gia_tri3,...);<\/code><\/pre>\n\n\n\n \n\n\n\n<\/span>C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo<\/span><\/h2>\n\n\n\nTrong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft l\u00e0 Northwind.<\/p>\n\n\n\n
B\u00ean d\u01b0\u1edbi l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”:<\/p>\n\n\n\nCustomerID<\/th> CustomerName<\/th> ContactName<\/th> Address<\/th> City<\/th> PostalCode<\/th> Country<\/th><\/tr> 87<\/td> Wartian Herkku<\/td> Pirkko Koskitalo<\/td> Torikatu 38<\/td> Oulu<\/td> 90110<\/td> Finland<\/td><\/tr> 88<\/td> Wellington Importadora<\/td> Paula Parente<\/td> Rua do Mercado, 12<\/td> Resende<\/td> 08737-363<\/td> Brazil<\/td><\/tr> 89<\/td> White Clover Markets<\/td> Karl Jablonski<\/td> 305 – 14th Ave. S. Suite 3B<\/td> Seattle<\/td> 98128<\/td> USA<\/td><\/tr> 90<\/td> Wilman Kala<\/td> Matti Karttunen<\/td> Keskuskatu 45<\/td> Helsinki<\/td> 21240<\/td> Finland<\/td><\/tr> 91<\/td> Wolski<\/td> Zbyszek<\/td> ul. Filtrowa 68<\/td> Walla<\/td> 01-012<\/td> Poland<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\n\n\n<\/span>V\u00ed d\u1ee5 v\u1ec1 INSERT INTO<\/span><\/h2>\n\n\n\nGi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi trong b\u1ea3ng “Customers”.<\/p>\n\n\n\n
Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL sau.<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/h3>\n\n\n\nINSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)\nVALUES ('Cardinal','Tom B. Erichsen','Skagen 21','Stavanger','4006','Norway');<\/code><\/pre>\n\n\n\nT\u00ean c\u1ed9t kh\u00f4ng c\u00f3 trong d\u1ea5u nh\u00e1y \u0111\u01a1n, gi\u00e1 tr\u1ecb n\u1eb1m trong d\u1ea5u nh\u00e1y \u0111\u01a1n. Ph\u00e2n c\u00e1ch nhau b\u1eb1ng d\u1ea5u ph\u1ea9y.<\/p>\n\n\n\n
L\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers” b\u00e2y gi\u1edd s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\nCustomerID<\/th> CustomerName<\/th> ContactName<\/th> Address<\/th> City<\/th> PostalCode<\/th> Country<\/th><\/tr> 87<\/td> Wartian Herkku<\/td> Pirkko Koskitalo<\/td> Torikatu 38<\/td> Oulu<\/td> 90110<\/td> Finland<\/td><\/tr> 88<\/td> Wellington Importadora<\/td> Paula Parente<\/td> Rua do Mercado, 12<\/td> Resende<\/td> 08737-363<\/td> Brazil<\/td><\/tr> 89<\/td> White Clover Markets<\/td> Karl Jablonski<\/td> 305 – 14th Ave. S. Suite 3B<\/td> Seattle<\/td> 98128<\/td> USA<\/td><\/tr> 90<\/td> Wilman Kala<\/td> Matti Karttunen<\/td> Keskuskatu 45<\/td> Helsinki<\/td> 21240<\/td> Finland<\/td><\/tr> 91<\/td> Wolski<\/td> Zbyszek<\/td> ul. Filtrowa 68<\/td> Walla<\/td> 01-012<\/td> Poland<\/td><\/tr> 92<\/td> Cardinal<\/td> Tom B. Erichsen<\/td> Skagen 21<\/td> Stavanger<\/td> 4006<\/td> Norway<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nB\u1ea1n c\u00f3 l\u01b0u \u00fd l\u00e0 ch\u00fang ta kh\u00f4ng th\u1ec3 ch\u00e8n b\u1ea5t c\u1ee9 s\u1ed1 n\u00e0o v\u00e0o trong tr\u01b0\u1eddng CustomerID?<\/p>\n\n\n\n
C\u1ed9t CustomerID \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt v\u1edbi gi\u00e1 tr\u1ecb duy nh\u1ea5t cho m\u1ed7i b\u1ea3n ghi trong b\u1ea3ng.<\/p>\n\n\n\n
\n\n\n\n<\/span>Ch\u1ec9 ch\u00e8n d\u1eef li\u1ec7u v\u00e0o trong c\u00e1c c\u1ed9t nh\u1ea5t \u0111\u1ecbnh<\/span><\/h2>\n\n\n\nCh\u00fang ta c\u00f3 kh\u1ea3 n\u0103ng ch\u1ec9 ch\u00e8n d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n\n\n\n
Theo SQL, c\u00e2u l\u1ec7nh s\u1ebd ch\u00e8n m\u1ed9t h\u00e0ng m\u1edbi, nh\u01b0ng ch\u1ec9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t “CustomerName”, “City”, v\u00e0 “Country” l\u00e0 \u0111\u01b0\u1ee3c ch\u00e8n (d\u0129 nhi\u00ean tr\u01b0\u1eddng CustomerID s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng).<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/h3>\n\n\n\nINSERT INTO Customers (CustomerName, City, Country)\nVALUES ('Cardinal', 'Stavanger', 'Norway');<\/code><\/pre>\n\n\n\nM\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customer” s\u1ebd tr\u00f4ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\nCustomerID<\/th> CustomerName<\/th> ContactName<\/th> Address<\/th> City<\/th> PostalCode<\/th> Country<\/th><\/tr> 87<\/td> Wartian Herkku<\/td> Pirkko Koskitalo<\/td> Torikatu 38<\/td> Oulu<\/td> 90110<\/td> Finland<\/td><\/tr> 88<\/td> Wellington Importadora<\/td> Paula Parente<\/td> Rua do Mercado, 12<\/td> Resende<\/td> 08737-363<\/td> Brazil<\/td><\/tr> 89<\/td> White Clover Markets<\/td> Karl Jablonski<\/td> 305 – 14th Ave. S. Suite 3B<\/td> Seattle<\/td> 98128<\/td> USA<\/td><\/tr> 90<\/td> Wilman Kala<\/td> Matti Karttunen<\/td> Keskuskatu 45<\/td> Helsinki<\/td> 21240<\/td> Finland<\/td><\/tr> 91<\/td> Wolski<\/td> Zbyszek<\/td> ul. Filtrowa 68<\/td> Walla<\/td> 01-012<\/td> Poland<\/td><\/tr> 92<\/td> Cardinal<\/td> null<\/td> null<\/td> Stavanger<\/td> null<\/td> Norway<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"C\u00e2u l\u1ec7nh INSERT INTO \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u00e8n b\u1ea3n ghi m\u1edbi v\u00e0o m\u1ed9t b\u1ea3ng. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u l\u1ec7nh SQL INSERT INTO C\u00f3 th\u1ec3 vi\u1ebft c\u00e2u l\u1ec7nh INSERT INTO th\u00e0nh hai d\u1ea1ng. D\u1ea1ng th\u1ee9 nh\u1ea5t kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh t\u00ean c\u1ed9t n\u01a1i d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n, ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang: D\u1ea1ng th\u1ee9 hai …<\/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":"\n
C\u00e2u l\u1ec7nh INSERT INTO trong SQL • Ki\u1ebfn c\u00e0ng<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n","yoast_head_json":{"title":"C\u00e2u l\u1ec7nh INSERT INTO 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-insert-into-trong-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e2u l\u1ec7nh INSERT INTO trong SQL • Ki\u1ebfn c\u00e0ng","og_description":"C\u00e2u l\u1ec7nh INSERT INTO \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u00e8n b\u1ea3n ghi m\u1edbi v\u00e0o m\u1ed9t b\u1ea3ng. C\u00fa ph\u00e1p c\u1ee7a c\u00e2u l\u1ec7nh SQL INSERT INTO C\u00f3 th\u1ec3 vi\u1ebft c\u00e2u l\u1ec7nh INSERT INTO th\u00e0nh hai d\u1ea1ng. D\u1ea1ng th\u1ee9 nh\u1ea5t kh\u00f4ng ch\u1ec9 \u0111\u1ecbnh t\u00ean c\u1ed9t n\u01a1i d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n, ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang: D\u1ea1ng th\u1ee9 hai …","og_url":"https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-25T04:36:47+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":"3 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/","url":"https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/","name":"C\u00e2u l\u1ec7nh INSERT INTO trong SQL • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-25T04:36:47+00:00","dateModified":"2016-07-25T04:36:47+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cau-lenh-insert-into-trong-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e2u l\u1ec7nh INSERT INTO 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\/3384"}],"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=3384"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3384\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}