Kumar Saurabh 
In this MariaDB tutorial, we will learn about the “MariaDB Create Sequence” which generates a number automatically. Additionally, we will also cover the following topics. MariaDB create sequence MariaDB drop sequence MariaDB alter sequence MariaDB create sequence if not exists MariaDB create sequence In MariaDB, the new sequence is created using the keyword CREATE SEQUENCE that … Read more >>
In this MariaDB tutorial, we are going to learn about MariaDB AUTO_INCREMENT. Additionally, we will cover the following topics. MariaDB AUTO_INCREMENT MariaDB AUTO_INCREMENT_OFFSET MariaDB AUTO_INCREMENT Reset MariaDB AUTO_INCREMENT By 2 and By 3 MariaDB AUTO_INCREMENT_INCREMENT MariaDB AUTO_INCREMENT Not Primary Key MariaDB AUTO_INCREMENT Max Value MariaDB AUTO_INCREMENT 0 MariaDB auto_increment uuid MariaDB auto_increment primary key MariaDB AUTO_INCREMENT … Read more >>
In this MariaDB tutorial, we will study the use of MariaDB Primary Key, and we will also cover some examples. The lists of topic that comes under discussion are given below: MariaDB Primary Key In MariaDB, a primary key is defined as one or more fields that uniquely identify a record in a table. A … Read more >>
The MariaDB delete row statement is one line: DELETE FROM orders WHERE id = 108; Leave out the WHERE and the whole table empties. My first filtered delete, on a non-key column, removed nothing: ERROR 1175, safe update mode. Quick answer: filter on the primary key, read ROW_COUNT() afterward, and wrap anything bigger in START … Read more >>
In this MariaDB tutorial, we will learn about MariaDB Full Outer Join. Additionally, we will cover the following topics. What is Full Outer Join Full Outer Join in MariaDB MariaDB Full Outer Join Using Union All What is Full Outer Join in Database Here, we will learn about the basics of Full Outer Join in … Read more >>
In this MariaDB tutorial, we will study the use of MariaDB Cast and we will also cover some examples. There are lists of the topic that comes under discussion is given below: MariaDB Cast MariaDB Cast DateTime to Date MariaDB Cast as BigInt MariaDB Cast as Date MariaDB Cast as String to DateTime MariaDB Cast … Read more >>
In this MariaDB tutorial, we will study the use of MariaDB Substring and we will also cover some examples. The lists of the topic that comes under discussion are given below: MariaDB Substring Function MariaDB Substring Index MariaDB Substring Find MariaDB Substring Regex MariaDB Substring Position Maraidb Substring Left Mariadb Substring Count Mariadb Substring Last Character … Read more >>
In this MariaDB tutorial, we will study the use of MariaDB Limit and we will also cover some examples. There are lists of the topic that comes under discussion is given below: MariaDB limit MariaDB limit offset MariaDB limit in subquery MariaDB limit connections per user MariaDB limit table size MariaDB limit The limit clause … Read more >>
Say your support team looks up orders by state all day, in a table of 5,004 orders. A MariaDB index fixes it: CREATE INDEX ix_state ON orders (state); cut that lookup from a full scan to 2 rows read. Below: single, composite, unique and JSON indexes, EXPLAIN checks, renames, drops and the foreign key error … Read more >>
This MariaDB tutorial explains, MariaDB varchar and covers the following topics. MariaDB varchar MariaDB varchar max length MariaDB varchar without length MariaDB varchar vs text vs char MariaDB varchar max size MariaDB varchar vs nvarchar MariaDB varchar index MariaDB varchar not null MariaDB varchar The VARCHAR is a data type that represents the character or … Read more >>