Skip to main content

MariaDB

database connection​

mysql -u <user> -p <password>

List Databases​

show databases;

Use database​

use <database-name>;

List tables​

show tables;
note

use database command should be executed before executing the above command

or

show tables from <database-name>;

list columns of the table​

List all the columns of the table Users

desc Users;