MariaDB Database Cheatsheet

MariaDB is a popular open-source relational database management system (RDBMS) that is widely used for building robust and scalable web applications. Whether you are a beginner or an experienced developer, having a cheatsheet at your fingertips can be incredibly helpful for quickly referencing essential commands and syntax. In this blog, we will provide you with a comprehensive MariaDB cheatsheet organized with helpful code snippets.

1. Connecting to MariaDB

Connect to MariaDB Server

mysql -u username -p

Connect to a Specific Database

USE database_name;

2. Working with Databases

Create a Database

CREATE DATABASE database_name;

Show all Databases

SHOW DATABASES;

Delete a Database

DROP DATABASE database_name;

3. Managing Tables

Create a Table

CREATE TABLE table_name (
  column1 datatype,
  column2 datatype,
  ...
);

Show Table Structure

DESCRIBE table_name;

Delete a Table

DROP TABLE table_name;

4. Inserting Data

Insert Single Record

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

Insert Multiple Records

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...),
       (value1, value2, ...),
       ...;

5. Querying Data

Select All Records

SELECT * FROM table_name;

Select Specific Columns

SELECT column1, column2 FROM table_name;

Filter Data with WHERE

SELECT * FROM table_name WHERE condition;

6. Updating and Deleting Data

Update Records

UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

Delete Records

DELETE FROM table_name WHERE condition;

7. Indexing

Create an Index

CREATE INDEX index_name ON table_name (column1, column2, ...);

Show Indexes

SHOW INDEXES FROM table_name;

8. User Management

Create a User

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

Grant Privileges

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Revoke Privileges

REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'localhost';

This MariaDB cheatsheet covers essential commands for connecting to the database, managing databases and tables, inserting and querying data, updating and deleting records, working with indexes, and user management. Bookmark this cheatsheet for quick reference, and boost your productivity when working with MariaDB!

FAQ