Mariadb Tutorial

MariaDB COUNT() Function In MariaDB database, COUNT function is used to return the count of an expression. Syntax: SELECT COUNT(aggregate_expression) FROM tables…

Create Database Create a database named “Products”. Syntax: CREATE DATABASE Database_name; Example: CREATE DATABASE Products; Show Database SHOW DATABASES command is used…

CREATE Table In MariaDB, CREATE TABLE statement is used to create table within a selected database. Syntax: CREATE TABLE table_name (column_name column_type);…

MariaDB Data Types Following is a list of data types in MariaDB: String data types Numeric data types Date/time data types Large…

MariaDB DELETE Data The MariaDB DELETE statement is used to delete one or more records from the table in MariaDB database. Syntax:…

MariaDB DISTINCT Clause MariaDB DISTINCT Clause is used to remove duplicates from the result when we use it with SELECT statement. Syntax:…

Drop Database DROP DATABASE command is used to drop the database you had created. Syntax: DROP DATABASE Database_name; Example: In the previous…

DROP Table In MariaDB, DROP TABLE statement is used to drop a table from a database. It deletes the tables permanently and…