{"id":4775,"date":"2020-04-15T17:56:57","date_gmt":"2020-04-15T10:56:57","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4775"},"modified":"2020-04-15T17:56:57","modified_gmt":"2020-04-15T10:56:57","slug":"huong-dan-su-ly-loi-mysql-1064-error","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/huong-dan-su-ly-loi-mysql-1064-error\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed l\u00fd l\u1ed7i &#8220;MySQL 1064 Error&#8221;"},"content":{"rendered":"<p>&#8220;MySQL 1064 Error&#8221; l\u00e0 l\u1ed7i c\u00fa ph\u00e1p. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u00f3 m\u1ed9t v\u1ea5n \u0111\u1ec1 n\u00e0o \u0111\u00f3\u00a0 MySQL kh\u00f4ng hi\u1ec3u b\u1ea1n \u0111ang y\u00eau c\u1ea7u n\u00f3 l\u00e0m g\u00ec. C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn l\u1ed7i n\u00e0y nh\u01b0ng c\u01a1 b\u1ea3n nh\u1ea5t l\u00e0\u00a0 l\u00e0 l\u1ec7nh SQL sai d\u1eabn \u0111\u1ebfn MySQL kh\u00f4ng th\u1ec3 s\u1eed l\u00fd.<\/p>\n<p><span style=\"font-size: 18pt;\">C\u00e1ch x\u1eed l\u00fd l\u1ed7i &#8220;MySQL 1064 Error&#8221;<\/span><\/p>\n<p><em>Ki\u1ec3m tra l\u1ec7nh SQL<\/em><\/p>\n<p>Nguy\u00ean\u00a0 nh\u00e2n ch\u00ednh xu\u1ea5t ph\u00e1t t\u1eeb c\u00fa ph\u00e1p l\u1ec7nh sql n\u00ean b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra\u00a0 l\u1ec7nh sql b\u1eb1ng c\u00e1c tool tr\u1ef1c tuy\u1ebfn: <a href=\"https:\/\/www.eversql.com\/sql-syntax-check-validator\/\" rel=\"nofollow noopener\" target=\"_blank\">VD t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-4776\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38.png\" alt=\"\" width=\"1281\" height=\"929\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38.png 1281w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38-300x218.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38-1024x743.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.44.38-768x557.png 768w\" sizes=\"(max-width: 1281px) 100vw, 1281px\" \/><\/a><\/p>\n<p><em>Ki\u1ec3m tra t\u01b0\u01a1ng th\u00edch\u00a0 m\u00e1y ch\u1ee7\u00a0 database khi th\u1ef1c hi\u1ec7n\u00a0 di d\u1eddi website.<\/em><\/p>\n<p>n\u1ebfu b\u1ea1n \u0111ang di chuy\u1ec3n trang web WordPress c\u1ee7a m\u00ecnh sang m\u1ed9t m\u00e1y ch\u1ee7 m\u1edbi ho\u1eb7c di chuy\u1ec3n n\u00f3 sang m\u1ed9t m\u00e1y ch\u1ee7 kh\u00e1c, b\u1ea1n s\u1ebd c\u1ea7n th\u1ef1c hi\u1ec7n th\u00eam c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 tr\u00e1nh g\u00e2y ra s\u1ef1 c\u1ed1 v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.<\/p>\n<p><span>Gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng plugin migrate bao g\u1ed3m ch\u1ebf \u0111\u1ed9 t\u01b0\u01a1ng th\u00edch, ch\u1eb3ng h\u1ea1n nh\u01b0 <\/span><a href=\"https:\/\/vi.wordpress.org\/plugins\/wp-migrate-db\/\" rel=\"nofollow noopener\" target=\"_blank\"><span>WP Migrate DB<\/span><\/a><span>\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-4777\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06.png\" alt=\"\" width=\"1281\" height=\"929\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06.png 1281w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06-300x218.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06-1024x743.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-15-at-17.55.06-768x557.png 768w\" sizes=\"(max-width: 1281px) 100vw, 1281px\" \/><\/a><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tick v\u00e0o m\u1ee5c &#8220;Compatible with older versions of MySQL (pre-5.5)&#8221; \u0111\u1ec3 t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00e1c phi\u00ean b\u1ea3n databse server c\u0169 h\u01a1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;MySQL 1064 Error&#8221; l\u00e0 l\u1ed7i c\u00fa ph\u00e1p. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 c\u00f3 m\u1ed9t v\u1ea5n \u0111\u1ec1 n\u00e0o \u0111\u00f3\u00a0 MySQL kh\u00f4ng hi\u1ec3u b\u1ea1n \u0111ang y\u00eau c\u1ea7u n\u00f3 l\u00e0m g\u00ec. C\u00f3 nhi\u1ec1u nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn l\u1ed7i n\u00e0y nh\u01b0ng c\u01a1 b\u1ea3n nh\u1ea5t l\u00e0\u00a0 l\u00e0 l\u1ec7nh SQL sai d\u1eabn \u0111\u1ebfn MySQL kh\u00f4ng th\u1ec3 s\u1eed l\u00fd. C\u00e1ch x\u1eed l\u00fd [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5167],"class_list":["post-4775","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-cau-hoi-chung-ve-wordpress"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=4775"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4775\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/16424"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=4775"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4775"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}