Table

• List database tables: show table, [[\dt *.*]]
• Delete rows of a table

Related terms

• mariadbcheck
• MariaDB: MyISAM, InnoDB
• DESCRIBE TABLE_NAME
• ALTER TABLE_NAME
• iptables
• External table
• DMS
• Foreign table
• Table Partitioning

GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx;

GRANT SELECT ON mytable TO xxx

Activities

1. 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, Hash table
• 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, RDMS