MariaDB Joins In MariaDB database, JOINS are used to retrieve data from multiple tables. It is performed when we have two or…
Mariadb Tutorial
-
-
MariaDB AVG() Function MariaDB AVG() function is used to retrieve the average value of an expression. Syntax: SELECT AVG(aggregate_expression) FROM tables [WHERE…
-
MariaDB Insert Data In MariaDB, INSERT INTO statement is used to insert data in a selected table. Syntax: INSERT INTO tablename (field,field2,…)…
-
MariaDB Comparison Operator MongoDB Comparison Operator is used to test for equality and inequality, as well as the more advanced operators. Comparison…
-
MariaDB Installation To perform any operation in MariaDB database, you need to install MariaDB database. To install MariaDB database on Windows Operating…
-
MariaDB Conditions Following is a list of conditions which are used in MariaDB with CRUD operation. Conditions are generally used with SELECT…
-
MariaDB INTERSECT Operator INTERSECT Operator is used to return intersection of 2 or more tables. If a record exists in both tables,…
-
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);…