{"id":13815,"date":"2021-08-12T15:11:00","date_gmt":"2021-08-12T15:11:00","guid":{"rendered":"https:\/\/freehost.page\/?p=13815"},"modified":"2021-08-12T15:11:00","modified_gmt":"2021-08-12T15:11:00","slug":"chuyen-excel-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/chuyen-excel-sql\/","title":{"rendered":"C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL"},"content":{"rendered":"\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean 1000 h\u00e0ng, l\u00fac n\u00e0y nh\u1eadp th\u1ee7 c\u00f4ng v\u00e0o MySQL s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian. H\u00f4m nay t\u00f4i s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u.<\/p>\n\n\n\n

B\u01b0\u1edbc 1: b\u1ea1n up file Excel l\u00ean Google Drive, s\u1eed d\u1ee5ng Google b\u1ea3ng t\u00ednh \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u.<\/p>\n\n\n\n

B\u01b0\u1edbc 2: ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u, \u0111\u1eb7c bi\u1ec7t ch\u00fa \u00fd t\u00ean c\u1ed9t. C\u00e1c c\u1ed9t d\u1eef li\u1ec7u ph\u1ea3i c\u00f3 t\u00ean, n\u00ean \u0111\u1ec3 kh\u00f4ng d\u1ea5u \u0111\u1ec3 vi\u1ec7c nh\u1eadp v\u00e0o MySQL \u0111\u01b0\u1ee3c d\u1ec5 d\u00e0ng.<\/p>\n\n\n\n

V\u00ed d\u1ee5:<\/p>\n\n\n\n

hoten<\/strong><\/td>gioi<\/strong><\/td><\/tr>
Nguy\u1ec5n \u0110\u1ee9c Anh<\/td>nam<\/td><\/tr>
Ng\u00f4 Ki\u1ec1u Trang<\/td>n\u1eef<\/td><\/tr>
Tr\u1ecbnh Minh Tu\u1ea5n<\/td>nam<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

B\u01b0\u1edbc 3: chuy\u1ec3n file th\u00e0nh d\u1ea1ng CSV, b\u1eb1ng c\u00e1ch v\u00e0o T\u1ec7p > T\u1ea3i xu\u1ed1ng > CSV. Google b\u1ea3ng t\u00ednh s\u1ebd xu\u1ea5t d\u1eef li\u1ec7u CSV cho b\u1ea1n.<\/p>\n\n\n\n

B\u01b0\u1edbc 4: d\u00f9ng \u1ee9ng d\u1ee5ng tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 chuy\u1ec3n file .csv th\u00e0nh .sql, c\u00e2u l\u1ec7nh \u0111\u1ec3 b\u1ea1n tra l\u00e0 “convert csv to sql”. V\u00ed d\u1ee5 v\u1ec1 m\u1ed9t trang web l\u00e0m nhi\u1ec7m v\u1ee5 n\u00e0y r\u1ea5t t\u1ed1t: convertcsv.com\/csv-to-sql.htm<\/a><\/p>\n\n\n\n

Ti\u1ebfp \u0111\u1ebfn b\u1ea1n up file .csv l\u00ean, h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1ea5y h\u00e0ng \u0111\u1ea7u ti\u00ean l\u00e0m t\u00ean c\u1ed9t, trong v\u00ed d\u1ee5 tr\u00ean l\u00e0 hoten va gioi. Trong b\u01b0\u1edbc n\u00e0y b\u1ea1n c\u0169ng ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u cho tr\u01b0\u1eddng, v\u00ed d\u1ee5 VARCHAR hay Interger, Text, v\u00e2n v\u00e2n. <\/p>\n\n\n\n

\u1ede \u0111\u00e2y b\u1ea1n c\u0169ng ch\u1ecdn lu\u00f4n t\u00ean b\u1ea3ng c\u1ee7a m\u00ecnh \u1edf ch\u1ed7 mytable. R\u1ed3i b\u1ea1n nh\u1ea5n CSV to SQL insert \u0111\u1ec3 n\u00f3 xu\u1ea5t ra c\u00e1c t\u00f9y ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n

Cu\u1ed1i c\u00f9ng b\u1ea1n t\u1ea3i file .sql v\u1ec1.<\/p>\n\n\n\n

V\u1edbi c\u00e1ch tr\u00ean t\u00f4i \u0111\u00e3 chuy\u1ec3n m\u1ed9t b\u1ea3ng excel c\u00f3 h\u01a1n 240 ng\u00e0n h\u00e0ng d\u1eef li\u1ec7u th\u00e0nh c\u00f4ng.<\/p>\n\n\n\n

\u0110\u1ed1i v\u1edbi file .sql n\u1eb7ng, b\u1ea1n c\u00f3 th\u1ec3 n\u00e9n n\u00f3 th\u00e0nh d\u1ea1ng .zip \u0111\u1ec3 vi\u1ec7c t\u1ea3i l\u00ean MySQL d\u1ec5 d\u00e0ng h\u01a1n (\u0111\u00f4i khi m\u1ed9t s\u1ed1 h\u1ec7 th\u1ed1ng MySQL y\u00eau c\u1ea7u ph\u1ea3i t\u1ea3i l\u00ean file .zip, ho\u1eb7c h\u1ecd gi\u1edbi h\u1ea1n dung l\u01b0\u1ee3ng file t\u1ea3i l\u00ean), ph\u1ea7n m\u1ec1m n\u00e9n mi\u1ec5n ph\u00ed \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c file .zip l\u00e0 7-zip<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean 1000 h\u00e0ng, l\u00fac n\u00e0y nh\u1eadp th\u1ee7 c\u00f4ng v\u00e0o MySQL s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian. H\u00f4m nay t\u00f4i s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. B\u01b0\u1edbc 1: b\u1ea1n up file Excel l\u00ean Google Drive, s\u1eed d\u1ee5ng Google b\u1ea3ng t\u00ednh \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[238],"tags":[],"yoast_head":"\nC\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • 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\/chuyen-excel-sql\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean 1000 h\u00e0ng, l\u00fac n\u00e0y nh\u1eadp th\u1ee7 c\u00f4ng v\u00e0o MySQL s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian. H\u00f4m nay t\u00f4i s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. B\u01b0\u1edbc 1: b\u1ea1n up file Excel l\u00ean Google Drive, s\u1eed d\u1ee5ng Google b\u1ea3ng t\u00ednh \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/chuyen-excel-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=\"2021-08-12T15:11:00+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\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • 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\/chuyen-excel-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • Ki\u1ebfn c\u00e0ng","og_description":"Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean 1000 h\u00e0ng, l\u00fac n\u00e0y nh\u1eadp th\u1ee7 c\u00f4ng v\u00e0o MySQL s\u1ebd r\u1ea5t m\u1ea5t th\u1eddi gian. H\u00f4m nay t\u00f4i s\u1ebd chia s\u1ebb v\u1edbi b\u1ea1n c\u00e1ch l\u00e0m \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u. B\u01b0\u1edbc 1: b\u1ea1n up file Excel l\u00ean Google Drive, s\u1eed d\u1ee5ng Google b\u1ea3ng t\u00ednh \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef …","og_url":"https:\/\/kiencang.net\/chuyen-excel-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2021-08-12T15:11:00+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\/chuyen-excel-sql\/","url":"https:\/\/kiencang.net\/chuyen-excel-sql\/","name":"C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2021-08-12T15:11:00+00:00","dateModified":"2021-08-12T15:11:00+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/chuyen-excel-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/chuyen-excel-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/chuyen-excel-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL"}]},{"@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\/13815"}],"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=13815"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/13815\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=13815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=13815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=13815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}