MariaDB LIKE Clause In MariaDB, LIKE clause is used with SELECT statement to retrieve data when an operation needs an exact match.…
Tag:
statement
-
-
MariaDB WHERE Clause In MariaDB, WHERE clause is used with SELECT, INSERT, UPDATE and DELETE statement to select or change a specific…
-
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…
-
MariaDB Export Export a MariaDB database using HeidiSQL We have a database named “tutoraspire”, having some tables within it. Right click on…
-
Features of MariaDB MariaDB provides the same features of MySQL with some extensions. It is relatively new and advance. Following is a…