Kumar Saurabh

Want the next ID to be 5000? That’s the whole MariaDB set auto increment value job, one ALTER TABLE: Next insert: Tested on MariaDB 13.0.2 with InnoDB tables. Set the Start Value in CREATE TABLE Put AUTO_INCREMENT = n after the column list. This is the sample table every query below resets to (the AUTO_INCREMENT … Read more >>

If you are working with date and time data in MariaDB, you may need to convert strings to date/time values in order to perform various operations on the data. MariaDB provides several functions and techniques that you can use to perform this conversion. In this MariaDB tutorial, we will explore some of the most common … Read more >>

Use COLUMN_TYPE from information_schema.COLUMNS when a script needs the MariaDB show column data type answer. Use DESCRIBE when you’re just looking: Three columns, three surprises: That’s my verdict after testing each method on MariaDB 13.0.2. I declared is_active as BOOLEAN and prefs as JSON. Neither survived. The Sample Tables I Tested On Every query below … Read more >>

In this article, we’ll look at MariaDB’s ALTER TABLE ADD Column statements, which let you add columns with default values to an already-existing table. On larger tables, we will also comprehend the effects of creating a column with a default value and later adding and modifying the column with a value. You have to add … Read more >>

Here, we’ll go through how to delete a database in MariaDB and how to do so using the DROP DATABASE statement on the MariaDB Server. To aid you in understanding the topic better, we will debate and draw conclusions about a number of examples. The topics we will cover are listed below. MariaDB How to … Read more >>

This MariaDB tutorial will teach how to create views in the MariaDB server. In this section, we’ll examine and wrap up a few scenarios to help you better comprehend the subject. Below is a list of every subject we’ll cover. How to create a view on the table in the MariaDB? How to create a … Read more >>

In this MariaDB lesson, you’ll learn how to use the MariaDB GROUP BY clause to construct views in the table. To assist you in better understanding the topic, we’ll investigate and wrap up a few examples in this part. The topics we will cover are listed below. How can we use the MariaDB GROUP BY … Read more >>

The Add Data To Table MariaDB statement simply utilizes an INSERT INTO statement from the MariaDB Server, and data is inserted into the table. And this is what this MariaDB tutorial will discuss. We will discuss and conclude several scenarios to help you better comprehend the subject. Below is a list of every topic we’ll … Read more >>

Every new app should get its own MariaDB database and its own login, so a bug in one app can’t read or drop another app’s tables. Quick answer: run CREATE DATABASE app_db;, then CREATE USER ‘app’@’localhost’ IDENTIFIED BY ‘password’; and GRANT ALL PRIVILEGES ON app_db.* TO ‘app’@’localhost’;. You don’t need FLUSH PRIVILEGES. In this tutorial, … Read more >>

The MariaDB Alter Table If Exists statement will be covered in detail, along with several examples, in this MariaDB tutorial. There are listings of the subject matter that is discussed: MariaDB Alter Table If Exists MariaDB Alter Table Drop Index If Exists MariaDB Alter Table Add Index If Not Exists MariaDB Alter Table Add Constraint … Read more >>