WEBINAR
MariaDB 101: Learning the Basics of MariaDB
A quick reference guide for essential SQL statements in MariaDB, categorized by Data Definition, Data Manipulation, and Transaction Control.
This page lists the most important SQL statements and contains links to their documentation pages. If you need a basic tutorial on how to use the MariaDB database server and how to execute simple commands, see A MariaDB Primer.
Also see Common MariaDB Queries for examples of commonly-used queries.
is used to create a new, empty database.
is used to completely destroy an existing database.
is used to select a default database.
is used to create a new table, which is where your data is actually stored.
is used to modify an existing table's definition.
is used to completely destroy an existing table.
shows the structure of a table.
is used when you want to read (or select) your data.
is used when you want to add (or insert) new data.
is used when you want to change (or update) existing data.
is used when you want to remove (or delete) existing data.
is used to begin a transaction.
is used to apply changes and end transaction.
is used to discard changes and end transaction.
The first version of this article was copied, with permission, from on 2012-10-05.
This page is licensed: CC BY-SA / Gnu FDL
REPLACE is used when you want to add or change (or replace) new or existing data.
TRUNCATE is used when you want to empty (or delete) all data from the template.
CREATE DATABASE mydb;
USE mydb;
CREATE TABLE mytable ( id INT PRIMARY KEY, name VARCHAR(20) );
INSERT INTO mytable VALUES ( 1, 'Will' );
INSERT INTO mytable VALUES ( 2, 'Marry' );
INSERT INTO mytable VALUES ( 3, 'Dean' );
SELECT id, name FROM mytable WHERE id = 1;
UPDATE mytable SET name = 'Willy' WHERE id = 1;
SELECT id, name FROM mytable;
DELETE FROM mytable WHERE id = 1;
SELECT id, name FROM mytable;
DROP DATABASE mydb;
SELECT COUNT(1) FROM mytable; gives the NUMBER OF records IN the TABLEWEBINAR
MariaDB 101: Learning the Basics of MariaDB