{"id":2684,"date":"2019-10-21T09:48:58","date_gmt":"2019-10-21T02:48:58","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&p=2684"},"modified":"2019-10-21T09:48:58","modified_gmt":"2019-10-21T02:48:58","slug":"quan-ly-co-so-du-lieu-voi-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/quan-ly-co-so-du-lieu-voi-phpmyadmin\/","title":{"rendered":"Qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u1edbi phpMyAdmin"},"content":{"rendered":"
\n
\n
\n

phpMyAdmin l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 qu\u1ea3n tr\u1ecb MySQL tr\u00ean giao di\u1ec7n Web nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng. N\u00f3 cung c\u1ea5p m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n th\u00f4ng qua tr\u00ecnh duy\u1ec7t c\u1ee7a b\u1ea1n.<\/em><\/p>\n<\/div>\n<\/div>\n

<\/span>M\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a c\u00f4ng c\u1ee5 phpMyAdmin l\u00e0 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. H\u01b0\u1edbng d\u1eabn n\u00e0y gi\u1ea3i th\u00edch c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ch\u1ee9c n\u0103ng kh\u00e1c nhau m\u00e0 phpMyAdmin cung c\u1ea5p \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/p>\n

Thao t\u00e1c c\u01a1 b\u1ea3n<\/h2>\n

Giao di\u1ec7n m\u1edbi khi b\u1ea1n m\u1edbi \u0111\u0103ng nh\u1eadp v\u00e0o phpMyAdmin.<\/p>\n

\"\"<\/figure>\n

T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/strong><\/h4>\n

\u1ede c\u1ed9t b\u00ean tr\u00e1i, click ch\u1ecdn \u201cNew\u201d sau \u0111\u00f3 nh\u1eadp v\u00e0o t\u00ean CSDL c\u1ee7a b\u1ea1n r\u1ed3i ch\u1ecdn \u201cCreate\u201d<\/p>\n

\"\"<\/figure>\n
T\u1ea1o b\u1ea3ng<\/strong><\/h5>\n

Ch\u1ecdn 1 CSDL, ch\u1ecdn \u201cCreate table\u201d \u0111\u1ec3 t\u1ea1o b\u1ea3ng m\u1edbi. Ch\u00fa \u00fd \u0111\u1eb7t t\u00ean b\u1ea3ng v\u00e0 ch\u1ecdn s\u1ed1 c\u1ed9t c\u00f3 trong b\u1ea3ng. Sau \u0111\u00f3 ch\u1ecdn \u201cGo\u201d \u0111\u1ec3 ho\u00e0n th\u00e0nh t\u1ea1o b\u1ea3ng.<\/p>\n

\"\"<\/figure>\n

Ti\u1ebfp theo b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n c\u1ea5u h\u00ecnh c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn<\/p>\n

\"\"<\/figure>\n

C\u1ee5 th\u1ec3:<\/p>\n

    \n
  • Name<\/strong>\u00a0\u2013 T\u00ean c\u1ee7a c\u1ed9t;<\/li>\n
  • Type<\/strong>\u00a0\u2013 Lo\u1ea1i d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u trong c\u1ed9t;<\/li>\n
  • Length\/Values<\/strong>\u00a0\u2013 \u0110\u1ed9 d\u00e0i c\u1ee7a tr\u01b0\u1eddng;<\/li>\n
  • Default\u00a0<\/strong>\u2013 t\u00f9y ch\u1ecdn gi\u00fap b\u1ea1n \u0111\u1eb7t gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh cho c\u1ed9t. \u0110i\u1ec1u n\u00e0y s\u1ebd h\u1eefu \u00edch trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n c\u1ea7n \u0111\u1eb7t d\u1ea5u th\u1eddi gian;<\/li>\n
  • Collation<\/strong>\u00a0\u2013 \u0110\u1ed1i chi\u1ebfu d\u1eef li\u1ec7u cho t\u1eebng tr\u01b0\u1eddng;<\/li>\n
  • Attributes<\/strong>\u00a0\u2013 G\u00e1n b\u1ea5t k\u1ef3 thu\u1ed9c t\u00ednh \u0111\u1eb7c bi\u1ec7t n\u00e0o cho tr\u01b0\u1eddng;<\/li>\n
  • Null<\/strong>\u00a0\u2013 X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb c\u1ee7a tr\u01b0\u1eddng c\u00f3 th\u1ec3 \u0111\u1ec3 tr\u00f3ng hay kh\u00f4ng;<\/li>\n
  • Index<\/strong>\u00a0\u2013 \u0110\u1eb7t ch\u1ec9 m\u1ee5c ho c\u00e1c h\u00e0ng;<\/li>\n
  • A_I<\/strong>\u00a0\u2013 vi\u1ebft t\u1eaft c\u1ee7a Auto Increment. N\u1ebfu t\u00f9y ch\u1ecdn n\u00e0y \u0111\u01b0\u1ee3c b\u1eadt th\u00ec c\u00e1c gi\u00e1 tr\u1ecb trong tr\u01b0\u1eddng c\u1ee7a c\u1ed9t s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u0103ng l\u00ean;<\/li>\n
  • Comments<\/strong>\u00a0\u2013 B\u1ea1n c\u00f3 th\u1ec3 th\u00eam nh\u1eadn x\u00e9t t\u1ea1i \u0111\u00e2y.<\/li>\n<\/ul>\n

    S\u1eed d\u1ee5ng\u00a0\u201cPreview SQL\u201d<\/strong>\u00a0\u0111\u1ec3 xem xem c\u00e1c thao t\u00e1c tr\u00ean d\u01b0\u1edbi d\u1ea1ng c\u00e2u l\u1ec7nh truy v\u1ea5n, ch\u1ecdn \u201cSave\u201d \u0111\u1ec3 l\u01b0u c\u1ea5u h\u00ecnh v\u1edbi b\u1ea3ng.<\/p>\n

    T\u00ecm hi\u1ec3u c\u00e1c tab \u0111\u1ec3 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/h2>\n

    Khi b\u1ea1n m\u1edf trang ch\u1ee7 phpMyAdmin, b\u1ea5m v\u00e0o tab\u00a0Database<\/strong>.<\/p>\n

    \"\"<\/figure>\n

    Sau \u0111\u00f3 ch\u1ecdn c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u1ec3 qu\u1ea3n l\u00fd b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o t\u00ean c\u1ee7a n\u00f3.<\/p>\n

    \"\"<\/figure>\n

    Trong trang m\u1edf ra, b\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t danh s\u00e1ch v\u1edbi c\u00e1c b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, c\u00e1c h\u00e0nh \u0111\u1ed9ng \u0111\u01b0\u1ee3c ph\u00e9p v\u1edbi ch\u00fang, s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n ghi, c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef, \u0111\u1ed1i chi\u1ebfu(Collation), k\u00edch th\u01b0\u1edbc c\u1ee7a b\u1ea3ng v\u00e0 chi ph\u00ed.<\/p>\n

    C\u00e1c h\u00e0nh \u0111\u1ed9ng b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n v\u1edbi b\u1ea3ng<\/h3>\n

    Browse<\/strong><\/h4>\n

    Ch\u1ec9 c\u00e1c b\u1ea3ng v\u1edbi c\u00e1c b\u1ea3n ghi hi\u1ec7n c\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c browse. Khi b\u1ea1n nh\u1ea5p v\u00e0o n\u00fat Browse, m\u1ed9t trang m\u1edbi v\u1edbi danh s\u00e1ch c\u00e1c b\u1ea3n ghi b\u00ean trong b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c m\u1edf.<\/p>\n

    \"\"<\/figure>\n

    Click v\u00e0o n\u00fat\u00a0edit<\/strong><\/em>, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u00e1c b\u1ea3n ghi \u0111\u00e3 ch\u1ecdn.<\/p>\n

    B\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y c\u1ea5u tr\u00fac b\u1ea3n ghi v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a b\u1ea3n ghi. Khi \u0111\u00e3 th\u1ef1c hi\u1ec7n xong c\u00e1c thay \u0111\u1ed5i, click v\u00e0o\u00a0\u201cGo\u201d<\/strong>\u00a0\u0111\u1ec3 l\u01b0u.<\/p>\n

    \"\"<\/figure>\n

    Structure<\/strong><\/h4>\n

    Click v\u00e0o n\u00fat\u00a0Structure<\/strong>, m\u1ed9t trang m\u1edbi s\u1ebd m\u1edf ra hi\u1ec3n th\u1ecb c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n

    \"\"<\/figure>\n

    B\u1ea1n s\u1ebd th\u1ea5y t\u00ean c\u1ee7a c\u00e1c tr\u01b0\u1eddng, lo\u1ea1i, t\u1eadp h\u1ee3p, thu\u1ed9c t\u00ednh, th\u00f4ng tin b\u1ed5 sung, gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh v\u00e0 li\u1ec7u c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a tr\u01b0\u1eddng c\u00f3 th\u1ec3 l\u00e0\u00a0NULL<\/strong>\u00a0hay kh\u00f4ng. B\u1ea1n c\u00f3 th\u1ec3 duy\u1ec7t c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng action t\u01b0\u01a1ng \u1ee9ng. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9nh s\u1eeda c\u1ea5u tr\u00fac c\u1ee7a m\u1ed9t tr\u01b0\u1eddng ho\u1eb7c x\u00f3a m\u1ed9t tr\u01b0\u1eddng. B\u1ea1n c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c ch\u1ec9 m\u1ee5c kh\u00e1c nhau:\u00a0Primary<\/strong>,\u00a0Unique<\/strong>,\u00a0Index\u00a0<\/strong>v\u00e0\u00a0Fulltext<\/strong>.<\/p>\n

    Search<\/strong><\/h4>\n

    V\u1edbi n\u00fat T\u00ecm ki\u1ebfm, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o truy v\u1ea5n t\u00ecm ki\u1ebfm cho b\u1ea3ng \u0111\u00e3 ch\u1ecdn.<\/p>\n

    \"\"<\/figure>\n

    B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng\u00a0Query by example<\/strong>\u00a0(truy v\u1ea5n theo v\u00ed d\u1ee5) \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ecm ki\u1ebfm. Ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng cho c\u00e1c tr\u01b0\u1eddng kh\u00e1c nhau cho c\u1ea5u tr\u00fac truy v\u1ea5n t\u00ecm ki\u1ebfm c\u1ee7a b\u1ea1n v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Go \u0111\u1ec3 th\u1ef1c hi\u1ec7n n\u00f3.<\/p>\n

    V\u00ed d\u1ee5:<\/em><\/strong>\u00a0n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi v\u1edbi gi\u00e1 tr\u1ecb tr\u01b0\u1eddng b\u1eaft \u0111\u1ea7u b\u1eb1ng \u201ca\u201d, tr\u01b0\u1edbc ti\u00ean b\u1ea1n n\u00ean ch\u1ecdn c\u00e1c tr\u01b0\u1eddng m\u00e0 b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb. Ch\u1ecdn to\u00e1n t\u1eed\u00a0LIKE\u00a0<\/strong>t\u1eeb menu th\u1ea3 xu\u1ed1ng v\u00e0 nh\u1eadp gi\u00e1 tr\u1ecb tr\u01b0\u1eddng t\u01b0\u01a1ng \u1ee9ng \u201ca%\u201d (% l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a chu\u1ed7i k\u00fd t\u1ef1 \u0111\u1ea1i di\u1ec7n). Nh\u1ea5p v\u00e0o n\u00fat Go \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/p>\n

    Insert<\/strong><\/h4>\n

    S\u1eed d\u1ee5ng n\u00fat\u00a0Insert<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n b\u1ea3n ghi v\u00e0o b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.<\/p>\n

    \"\"<\/figure>\n

    Ch\u1ecdn\u00a0\u201cGo\u201d<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n t\u1ea5t ch\u00e8n d\u1eef li\u1ec7u.<\/p>\n

    Empty<\/strong><\/h4>\n

    N\u00fat\u00a0Empty\u00a0<\/strong>cho ph\u00e9p b\u1ea1n l\u00e0m tr\u1ed1ng b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u, x\u00f3a d\u1eef li\u1ec7u v\u00e0 gi\u1eef b\u1ea3ng tr\u1ed1ng.<\/p>\n

    \"\"<\/figure>\n

    Drop<\/strong><\/h4>\n

    V\u1edbi n\u00fat\u00a0Drop<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi \u0111\u01b0\u1ee3c l\u01b0u trong \u0111\u00f3.<\/p>\n

    \"\"<\/figure>\n

    Ngo\u00e0i ra, phpMyAdmin c\u0169ng h\u1ed7 tr\u1ee3 b\u1ea1n\u00a0Export<\/strong>,\u00a0Import\u00a0<\/strong>d\u1eef li\u1ec7u v\u00e0 c\u1ea5u h\u00ecnh\u00a0Replication<\/strong>.<\/p>\n

    Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!!!<\/em><\/p>\n<\/div>\n

    <\/div>\n","protected":false},"excerpt":{"rendered":"

    phpMyAdmin l\u00e0 c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 qu\u1ea3n tr\u1ecb MySQL tr\u00ean giao di\u1ec7n Web nhanh ch\u00f3ng, d\u1ec5 d\u00e0ng. N\u00f3 cung c\u1ea5p m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n th\u00f4ng qua tr\u00ecnh duy\u1ec7t c\u1ee7a b\u1ea1n. M\u1ee5c \u0111\u00edch ch\u00ednh c\u1ee7a c\u00f4ng c\u1ee5 phpMyAdmin l\u00e0 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef […]<\/p>\n","protected":false},"author":7,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[28],"class_list":["post-2684","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-huong-dan-chung"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/2684","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=2684"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/2684\/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=2684"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=2684"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=2684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}