Difference between revisions of "Table"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | * [[Databases: list tables|List database tables]]: <code>[[show table]], <code>[[\dt *.*]]</code> | + | * [[Databases: list tables|List database tables]]: <code>[[show table]], <code><nowiki>[[\dt *.*]]</nowiki></code> |
* [[Delete rows of a table]] | * [[Delete rows of a table]] | ||
Revision as of 13:33, 23 November 2022
- List database tables:
show table,[[\dt *.*]] - Delete rows of a table
Related terms
mariadbcheck- MariaDB: MyISAM, InnoDB
DESCRIBE TABLE_NAMEALTER TABLE_NAMEiptables- External table
- DMS
- Foreign table
- Table Partitioning
GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx;
GRANT SELECT ON mytable TO xxx
Activities
- Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/
See also
- Table, foreign table, external table,
show table, Delete rows of a table, Table Partitioning, \dt
- Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid
Advertising:
