{"id":12413,"date":"2013-08-22T16:27:00","date_gmt":"2013-08-22T16:27:00","guid":{"rendered":"https:\/\/kiencang.net\/2013\/08\/22\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/"},"modified":"2013-08-22T16:27:00","modified_gmt":"2013-08-22T16:27:00","slug":"cach-tao-bang-trong-mysql-bang-phpmyadmin","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/","title":{"rendered":"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin"},"content":{"rendered":"\n

\u0110\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL, tr\u01b0\u1edbc ti\u00ean ta ph\u1ea3i c\u00f3 C\u01a1 S\u1edf D\u1eef Li\u1ec7u (CSDL). B\u1ea1n g\u00f5 t\u00ean CSDL v\u00e0o ph\u1ea7n\u00a0Creat new database<\/strong>, nh\u1edb \u0111\u1ec3 utf8_general_ci<\/code> \u0111\u1ec3 CSDL c\u00f3 th\u1ec3 l\u01b0u \u0111\u01b0\u1ee3c ti\u1ebfng Vi\u1ec7t, cu\u1ed1i c\u00f9ng nh\u1ea5n\u00a0Create<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Ti\u1ebfp theo b\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o l\u00e0 CSDL c\u00f3 t\u00ean mltc \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0ng kh\u00f4ng c\u00f3 b\u1ea3ng n\u00e0o b\u00ean trong (No tables found in database<\/em>).<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Nh\u00ecn sang b\u00ean ph\u1ea3i s\u1ebd th\u1ea5y n\u01a1i \u0111\u1ec3 t\u1ea1o B\u1ea3ng ( Create new table on database <\/em>):<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Trong tr\u01b0\u1eddng\u00a0Name<\/strong>\u00a0b\u1ea1n g\u00f5 t\u00ean c\u1ee7a b\u1ea3ng, trong v\u00ed d\u1ee5 n\u00e0y t\u00ean c\u1ee7a b\u1ea3ng l\u00e0 sanpham, \u1edf tr\u01b0\u1eddng\u00a0Number of fields<\/strong>\u00a0ch\u00ednh l\u00e0 s\u1ed1 c\u1ed9t c\u1ee7a b\u1ea3ng, \u1edf \u0111\u00e2y t\u00f4i \u0111\u1ec3 l\u00e0 4, c\u1ee5 th\u1ec3 th\u00ec \u00fd \u0111\u1ecbnh c\u1ee7a t\u00f4i l\u00e0 b\u1ea3ng n\u00e0y s\u1ebd c\u00f3 4 c\u1ed9t l\u00e0 m\u00e3 s\u1ea3n ph\u1ea9m, t\u00ean s\u1ea3n ph\u1ea9m, gi\u00e1 s\u1ea3n ph\u1ea9m v\u00e0 m\u00e0u s\u1eafc\u2026Ti\u1ebfp theo nh\u1ea5n Go\u2026B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c \u0111\u01b0a \u0111\u1ebfn khu v\u1ef1c \u0111\u1ec3 th\u00eam th\u00f4ng tin cho B\u1ea3ng gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n ch\u00fa \u00fd 2 tr\u01b0\u1eddng Field<\/code> v\u00e0 Type<\/code>\u2026Field<\/strong>\u00a0ch\u00ednh l\u00e0 t\u00ean c\u1ee7a c\u1ed9t, t\u00f4i s\u1ebd \u0111\u1ec3 t\u00ean c\u00e1c c\u1ed9t c\u1ee7a b\u1ea3ng sanpham l\u1ea7n l\u01b0\u1ee3t l\u00e0 ma_sp (c\u00e1i n\u00e0y l\u00e0 kh\u00f3a ch\u00ednh), ten_sp, gia_sp, mau_sac.\u00a0<\/p>\n\n\n\n

Type<\/strong>\u00a0ch\u00ednh l\u00e0 ki\u1ec3u c\u1ee7a d\u1eef li\u1ec7u, m\u1ed9t s\u1ed1 ki\u1ec3u ph\u1ed5 bi\u1ebfn l\u00e0 INT<\/code> (s\u1ed1 nguy\u00ean), TEXT<\/code> (v\u0103n b\u1ea3n c\u1ee1 l\u1edbn), VARCHAR<\/code> (k\u00fd t\u1ef1), DATE<\/code> (ng\u00e0y th\u00e1ng), FLOAT<\/code> (hay d\u00f9ng cho ti\u1ec1n t\u1ec7)\u2026<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

C\u00e1i Length\/Values l\u00e0 \u0111\u1ed9 d\u00e0i c\u1ee7a ki\u1ec3u d\u1eef li\u1ec7u\u2026Sau khi c\u1ea5u h\u00ecnh \u0111\u1ea7y \u0111\u1ee7 ta c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

B\u1ea1n nh\u1ea5n Save \u0111\u1ec3 t\u1ea1o b\u1ea3ng (nh\u1ea5n v\u00e0o h\u00ecnh \u0111\u1ec3 th\u1ea5y r\u00f5 h\u01a1n):<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

B\u1ea1n c\u1ea7n ch\u00fa \u00fd khu v\u1ef1c Action:<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Bi\u1ec3u t\u01b0\u1ee3ng c\u00e1i b\u00fat ch\u00ec d\u00f9ng \u0111\u1ec3 s\u1eeda c\u00e1c c\u1ed9t, ch\u1eb3ng h\u1ea1n mu\u1ed1n \u0111\u1ed5i t\u00ean, thay ki\u1ec3u d\u1eef li\u1ec7u, t\u0103ng gi\u1ea3m \u0111\u1ed9 d\u00e0i, d\u1ea5u X m\u00e0u \u0111\u1ecf \u0111\u1ec3 x\u00f3a c\u1ed9t, bi\u1ec3u t\u01b0\u1ee3ng ch\u00eca kh\u00f3a d\u00f9ng \u0111\u1ec3 t\u1ea1o kh\u00f3a. <\/p>\n\n\n\n

Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ma_sp l\u00e0 kh\u00f3a ch\u00ednh (PRIMARY KEY<\/code>) n\u00ean t\u00f4i s\u1ebd nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng kh\u00f3a \u1edf khu v\u1ef1c ma_sp. Khi ma_sp l\u00e0 kh\u00f3a, b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 \u0111\u01b0\u1ee3c g\u1ea1ch d\u01b0\u1edbi.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

P\/S: \u0110\u1ec3 th\u1ef1c h\u00e0nh t\u1ea1o b\u1ea3ng, ph\u1ea7n m\u1ec1m m\u00e0 t\u00f4i d\u00f9ng l\u00e0 XAMPP<\/a> \u2013 n\u00f3 ho\u00e0n to\u00e0n mi\u1ec5n ph\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0110\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL, tr\u01b0\u1edbc ti\u00ean ta ph\u1ea3i c\u00f3 C\u01a1 S\u1edf D\u1eef Li\u1ec7u (CSDL). B\u1ea1n g\u00f5 t\u00ean CSDL v\u00e0o ph\u1ea7n\u00a0Creat new database, nh\u1edb \u0111\u1ec3 utf8_general_ci \u0111\u1ec3 CSDL c\u00f3 th\u1ec3 l\u01b0u \u0111\u01b0\u1ee3c ti\u1ebfng Vi\u1ec7t, cu\u1ed1i c\u00f9ng nh\u1ea5n\u00a0Create. Ti\u1ebfp theo b\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o l\u00e0 CSDL c\u00f3 t\u00ean mltc \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0ng kh\u00f4ng c\u00f3 …<\/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 t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin • 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\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin • Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"\u0110\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL, tr\u01b0\u1edbc ti\u00ean ta ph\u1ea3i c\u00f3 C\u01a1 S\u1edf D\u1eef Li\u1ec7u (CSDL). B\u1ea1n g\u00f5 t\u00ean CSDL v\u00e0o ph\u1ea7n\u00a0Creat new database, nh\u1edb \u0111\u1ec3 utf8_general_ci \u0111\u1ec3 CSDL c\u00f3 th\u1ec3 l\u01b0u \u0111\u01b0\u1ee3c ti\u1ebfng Vi\u1ec7t, cu\u1ed1i c\u00f9ng nh\u1ea5n\u00a0Create. Ti\u1ebfp theo b\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o l\u00e0 CSDL c\u00f3 t\u00ean mltc \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0ng kh\u00f4ng c\u00f3 …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/\" \/>\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=\"2013-08-22T16:27:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i2.wp.com\/freehost.page\/wp-content\/uploads\/2013\/08\/csdl.png?resize=458%2C228&ssl=1\" \/>\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=\"4 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin • 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\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin • Ki\u1ebfn c\u00e0ng","og_description":"\u0110\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL, tr\u01b0\u1edbc ti\u00ean ta ph\u1ea3i c\u00f3 C\u01a1 S\u1edf D\u1eef Li\u1ec7u (CSDL). B\u1ea1n g\u00f5 t\u00ean CSDL v\u00e0o ph\u1ea7n\u00a0Creat new database, nh\u1edb \u0111\u1ec3 utf8_general_ci \u0111\u1ec3 CSDL c\u00f3 th\u1ec3 l\u01b0u \u0111\u01b0\u1ee3c ti\u1ebfng Vi\u1ec7t, cu\u1ed1i c\u00f9ng nh\u1ea5n\u00a0Create. Ti\u1ebfp theo b\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o l\u00e0 CSDL c\u00f3 t\u00ean mltc \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o nh\u01b0ng kh\u00f4ng c\u00f3 …","og_url":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2013-08-22T16:27:00+00:00","og_image":[{"url":"https:\/\/i2.wp.com\/freehost.page\/wp-content\/uploads\/2013\/08\/csdl.png?resize=458%2C228&ssl=1"}],"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":"4 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/","url":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/","name":"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2013-08-22T16:27:00+00:00","dateModified":"2013-08-22T16:27:00+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cach-tao-bang-trong-mysql-bang-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch t\u1ea1o b\u1ea3ng trong MySQL b\u1eb1ng phpMyAdmin"}]},{"@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\/12413"}],"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=12413"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/12413\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=12413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=12413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=12413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}