{"id":1333,"date":"2025-04-18T16:08:12","date_gmt":"2025-04-18T09:08:12","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1333"},"modified":"2025-04-18T16:08:12","modified_gmt":"2025-04-18T09:08:12","slug":"cara-menampilkan-semua-table-di-mysql-database","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/","title":{"rendered":"Cara Menampilkan Semua Table di MySQL Database"},"content":{"rendered":"

Saat mengelola database servers MySQL, salah satu tugas paling umum yang akan Anda lakukan adalah membiasakan diri dengan environment dari MySQL. Ini termasuk melihat daftar database<\/a> yang berada di server, menampilkan tabel database, atau mengambil informasi tentang akun pengguna<\/a> dan hak-hak istimewanya.<\/p>\n

Artikel ini menunjukkan cara melihat tabel di database MySQL atau MariaDB melalui baris perintah.<\/p>\n

Tampilkan Tabel MySQL<\/h2>\n

Untuk mendapatkan daftar tabel dalam database MySQL, gunakan tool\u00a0mysql<\/code>\u00a0client untuk terhubung ke MySQL\u00a0server dan menjalankan perintah SHOW TABLES<\/code>.<\/p>\n

Akses MySQL server:<\/p>\n

mysql -u user -p<\/pre>\n
Dari dalam MySQL shell, beralihlah ke database menggunakan pernyataan USE<\/code>:<\/p>\n
USE nama_database;<\/pre>\n
Jalankan perintah berikut untuk melihat daftar semua tabel dan tampilan dalam database saat ini:<\/p>\n
SHOW TABLES;<\/pre>\n
Outputnya akan terlihat seperti ini:<\/p>\n
+----------------------------+
\n| Tables_in_database_name    |
\n+----------------------------+
\n| actions         |
\n| permissions     |
\n| permissions_roles          |
\n| permissions_users          |
\n| roles|
\n| roles_users     |
\n| settings        |
\n| users|
\n+----------------------------+
\n8 rows in set (0.00 sec)<\/pre>\n
Modifier opsional FULL<\/code> akan menampilkan tipe tabel sebagai kolom output kedua.<\/p>\n
SHOW FULL TABLES;
\n<\/pre>\n
Outputnya akan terlihat seperti ini:<\/p>\n
+----------------------------+------------+
\n| Tables_in_database_name    | Table_type |
\n+----------------------------+------------+
\n| actions         | VIEW       |
\n| permissions     | BASE TABLE |
\n| permissions_roles          | BASE TABLE |
\n| permissions_users          | BASE TABLE |
\n| roles| BASE TABLE |
\n| roles_users     | BASE TABLE |
\n| settings        | BASE TABLE |
\n| users| BASE TABLE |
\n+----------------------------+------------+
\n
\n8 rows in set (0.00 sec)<\/pre>\n
Untuk melihat daftar tabel tanpa beralih ke database, gunakan klausa FROM<\/code>\u00a0atau IN<\/code>\u00a0diikuti dengan nama database:<\/p>\n
SHOW TABLES FROM nama_database_lain;
\n<\/pre>\n
Klausa LIKE<\/code>\u00a0dapat digunakan untuk memfilter output dari perintah SHOW TABLES<\/code> sesuai dengan pola tertentu.<\/p>\n
SHOW TABLES LIKE pattern;<\/pre>\n
Misalnya, pernyataan berikut akan mengembalikan semua database yang namanya dimulai dengan \u2018permissions\u2019:<\/p>\n
SHOW TABLES LIKE 'permissions%';<\/pre>\n
+-------------------------------------------+
\n| Tables_in_database_name (permissions%)    |
\n+-------------------------------------------+
\n| permissions         |
\n| permissions_roles   |
\n| permissions_users   |
\n+-------------------------------------------+
\n3 rows in set (0.00 sec)<\/pre>\n
Tanda persen (%<\/code>) berarti segala sesuatu yang berkaitan dengan kata permissions\u00a0<\/code> akan ditampilkan.<\/p>\n
Tampilkan Tabel MySQL dari Baris Perintah<\/h2>\n
Untuk mendapatkan informasi tentang tabel dari shell Linux, Anda dapat menggunakan perintah mysql -e<\/code> atau perintah mysqlshow<\/code> yang akan menampilkan informasi database dan tabel.<\/p>\n
Ini sangat berguna ketika Anda ingin bekerja dengan database MySQL Anda menggunakan skrip shell.<\/p>\n
Jalankan perintah berikut di terminal Anda untuk menampilkan daftar semua databases:<\/p>\n
mysql -u user -p -e 'SHOW TABLES FROM nama_database;'<\/pre>\n
Output akan menampilkan daftar semua tabel:<\/p>\n
+----------------------------+
\n| Tables_in_database_name    |
\n+----------------------------+
\n| actions         |
\n| permissions     |
\n| permissions_roles          |
\n| permissions_users          |
\n| roles|
\n| roles_users     |
\n| settings        |
\n| users|
\n+----------------------------+<\/pre>\n
Berikut ini adalah contoh menggunakan perintah mysqlshow<\/code>:<\/p>\n
mysqlshow database_name<\/pre>\n
Kesimpulan<\/h2>\n
Untuk mendapatkan informasi tentang tabel dalam database MySQL, gunakan perintah SHOW TABLES<\/code>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Saat mengelola database servers MySQL, salah satu tugas paling umum yang akan Anda lakukan adalah…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[99,41,166],"class_list":["post-1333","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mariadb","tag-mysql","tag-sql"],"yoast_head":"\nCara Menampilkan Semua Table di MySQL Database - Linuxid<\/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:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menampilkan Semua Table di MySQL Database - Linuxid\" \/>\n<meta property=\"og:description\" content=\"Saat mengelola database servers MySQL, salah satu tugas paling umum yang akan Anda lakukan adalah…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T09:08:12+00:00\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/\",\"name\":\"Cara Menampilkan Semua Table di MySQL Database - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"datePublished\":\"2025-04-18T09:08:12+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Menampilkan Semua Table di MySQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Menampilkan Semua Table di MySQL Database - Linuxid","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:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menampilkan Semua Table di MySQL Database - Linuxid","og_description":"Saat mengelola database servers MySQL, salah satu tugas paling umum yang akan Anda lakukan adalah…","og_url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/","og_site_name":"Linuxid","article_published_time":"2025-04-18T09:08:12+00:00","author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/","url":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/","name":"Cara Menampilkan Semua Table di MySQL Database - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"datePublished":"2025-04-18T09:08:12+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-menampilkan-semua-table-di-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Menampilkan Semua Table di MySQL Database"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1333"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1333\/revisions"}],"predecessor-version":[{"id":3055,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1333\/revisions\/3055"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}