Database CLI

This page contains some helpful commands to use at the MariaDB CLI.

1. >SHOW DATABASES; List all databases;
2. >USE <database>; Use a particular database, eg: >USE bplan;
3. >SHOW TABLES; List all tables in a database (after using USE);
4. >DESCRIBE <name of table>; Prints the structure of a table, eg: DESCRIBE tbl_entity;