convertcsv.com\/csv-to-sql.htm<\/a><\/p>\n\n\n\nTi\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":"\n
C\u00e1ch nh\u1eadp b\u1ea3ng d\u1eef li\u1ec7u Excel sang MySQL • 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\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}]}}