show tables (example)
Jump to navigation
Jump to search
show tables
MariaDB [your_database]> show tables; +-------------------------+ | Tables_in_your_database | +-------------------------+ | actor | | archive | | bot_passwords | | category | | categorylinks | | change_tag | | change_tag_def | | comment | | content | | content_models | | externallinks | | filearchive | | image | | imagelinks | | interwiki | | ip_changes | | ipblocks | | ipblocks_restrictions | | iwlinks | | job | | l10n_cache | | langlinks | | log_search | | logging | | module_deps | | objectcache | | oldimage | | page | | page_props | | page_restrictions | | pagelinks | | protected_titles | | querycache | | querycache_info | | querycachetwo | | recentchanges | | redirect | | revision | | revision_actor_temp | | revision_comment_temp | | searchindex | | site_identifiers | | site_stats | | sites | | slot_roles | | slots | | templatelinks | | text | | updatelog | | uploadstash | | user | | user_former_groups | | user_groups | | user_newtalk | | user_properties | | watchlist | +-------------------------+ 56 rows in set (0.00 sec)
See also[edit]
- SQL, NewSQL, RDMS: GraphQL (2015), SQLite,
select, insert
,select count
, Distributed SQL, TablePlus, Cache hit ratio,pg_stat_user_tables
,EXPLAIN
, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy,CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS
, Unique constraint,.sql
- MariaDB:
mariadbcheck
,mariabackup
,mysqldump
, MyRocks,show (MariaDB)
MariaDB Changelog,50-server.cnf
, MariaDB engines, .ibd, .myd, .myi,/var/log/mysql/error.log, /var/log/mysql/mariadb-slow.log
, MariaDB files:.frm
,.ibd
,/etc/mysql/mariadb.conf.d/50-server.cnf
, replication, MariaDB slow queries,show databases;
, Aria, MyISAM, MariaDB SkySQL, binary log, 3306,/etc/mysql/
Advertising: