Difference between revisions of "Table"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
* [[Foreign table]] | * [[Foreign table]] | ||
* [[Table Partitioning]] | * [[Table Partitioning]] | ||
| − | + | * <code>[[GRANT SELECT]] ON [[ALL TABLES]] IN [[SCHEMA]] public TO xxx;</code> | |
| − | + | * <code>[[GRANT SELECT]] ON mytable TO xxx</code> | |
| − | |||
== Activities == | == Activities == | ||
Revision as of 13:35, 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
- AWS Database Migration Service (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:
