mariadb-standard-developer_cheat-sheet - MariaDB client - SQL commands

Oct 14, 2026

A concise MariaDB standard developer cheat sheet focused on using the MariaDB command-line client to connect to a server, authenticate, and optionally select a specific database. It provides quick-reference SQL syntax for creating, altering, and dropping databases and tables, browsing schemas and fields, and performing core DML operations such as SELECT, INSERT, UPDATE, and DELETE. It also includes administrative tasks like listing users and creating, updating, and removing database users, plus connection options such as SSL and host/port parameters.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages2

Reading Time1 min

AccessFree to download

MariaDB Client CLI

Connection commands (host, port, database, SSL)

CREATE / ALTER / DROP / REMOVE

Browsing schemas, tables, and fields

USE database

SELECT and joins

INSERT / UPDATE / DELETE

Admin tasks (users, privileges)

MARIADB STANDARD DEVELOPER CHEAT SHEET MARIADB CLIENT CLI Connect and communicate with MariaDB using the MariaDB command-line client. mariadb -u [username] -p Connect to a MariaDB Server using a username and password (will prompt for password) mariadb -u [username] -p [database] mariadb -u [username] -p -D [database] Connect to a MariaDB Server and specify a database. Note that the first free parameter will be treated as a DB name; the DB name can also be given with the-D flag. | mariadb
number] | -h | [host_address] | -P | [port_ | | --- | --- | --- | --- | --- | | Connect to a MariaDB Server by specifying the host address and port number (default 3306) | | | | | mariadb --ssl Connect to a MariaDB Server with an encrypted connection. CREATE / ALTER / DROP / REMOVE Connect and communicate with MariaDB using the MariaDB command-line client. CREATE DATABASE database_name; Create a database DROP DATABASE [IF EXISTS] database_name; Drop a database CREATE TABLE [IF NOT EXISTS] table_name ( field name field type ); Create a table BROWSING Show details of schemas, tables and fields. | SHOW DATABASES; | | --- | | Show all available database in current MariaDB database server | | SHOW TABLES; | | Show all tables in a current database | | SHOW CREATE TABLE table_name; | | Show the create table statement that creates a specified table | SHOW FIELDS FROM table_name / DESCRIBE table_name; Show the field information for a specified table USE database_name; Use a database or change the current database to another database to use SELECT Select data from a MariaDB table. | SELECT * FROM table_name; | | | | --- | --- | --- | | Select all rows from a table | | | | SELECT column1, FROM table_name | column2, | … | | Select data from one or more columns | | | | DROP TABLE [IF EXISTS] table_name; | | | | Drop a table | | | | ALTER TABLE table_name MODIFY [COLUMN] field name field type [NOT NULL]; | | | | Modify an existing field | | | ALTER TABLE table_name ADD [COLUMN] field name field type [NOT NULL]; Add a new field to a table MARIADB EDUCATION CHEAT SHEET MARIADB STANDARD DEVELOPER ALTER TABLE table_name DROP [COLUMN] field name; Drop a column from a table ORDER BY field name[, field name][ASC] |DESC; Sorting a result set INSERT / UPDATE / DELETE Inserting, updating and deleting data within a MariaDB table | INSERT INTO table name (field name [, field name, . . . ]) VALUES (value [, value, …]); | | --- | | Insert a row into a table | | UPDATE table name SET field name = value [, field name = value, …])[WHERE condition]; | | Update rows in a table | | DELETE FROM table_name [WHERE condition]; | | Delete rows from a table | | SELECT field list FROM table_name WHERE condition; | | Select data with a filter using a WHERE clause | | SELECT field list FROM table_name WHERE condition
GROUP BY field name[, field name]; | | Grouping rows using the GROUP BY clause | SELECT field list SELECT field list FROM table_name_1 CROSS JOIN table_name_2; Select data from multiple tables using CROSS JOIN SELECT-JOIN Select data by joining multiple tables SELECT field list FROM table_name_1 LEFT JOIN table_name_2 ON condition; Select data from multiple tables using LEFT JOIN ADMIN TASKS Perform common admin tasks | SELECT user,host FROM mysql .user; | | | --- | --- | | List all users on the database instance | | | CREATE USER user[@'host'] IDENTIFIED BY 'plain-textpassword'; | | | Create a new user with a given password | | | SET PASSWORD FOR user[@'host'] = PASSWORD('new-plain-textpassword'); | | | Change the password for a user. Can also be done with ALTER USER | | | DROP USER user[@'host'] | | | Remove a user from the system | | | CREATE DATABASE db_name | | | Create a new, empty database with a given name | | | GRANT ALL ON db name .* user[@'host'] | TO | | Grant all privileges on a given database to a particular user. | | DR

FAQs

How do I connect to a MariaDB server using the command-line client?

Use mariadb with -u [username] -p to provide credentials, optionally add -h [host_address] and -P [port_], and include -D [database] to select a database. The page also lists mariadb --ssl for encrypted connections.

What SQL commands are included for managing databases and tables?

The sheet lists CREATE DATABASE, DROP DATABASE, CREATE TABLE, and DROP TABLE, plus ALTER TABLE variants for modifying, adding, and dropping columns.

Which operations are covered for querying and changing data?

It includes SELECT queries (including CROSS JOIN and LEFT JOIN with ON), sorting via ORDER BY, and data changes with INSERT INTO, UPDATE ... SET ... WHERE, and DELETE FROM ... WHERE.

Oct 14, 2026

Upload by River Wang