Database CLI

From acumen Wiki
Revision as of 17:20, 7 July 2020 by Jmoss2 (talk | contribs)
Jump to navigation Jump to search

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 ; Prints the structure of a table, eg: DESCRIBE tbl_entity;;
Retrieved from "http://wiki.acumen-tms.co.uk/index.php?title=Database_CLI&oldid=253"