Kumar Saurabh 
In this MariaDB tutorial, we will look at the differences between MariaDB and Postgres and some examples. MariaDB vs Postgres Open-source RDBMS (Relational Database Management System) such as PostgreSQL or MariaDB are likely to be at the top of the list when a company is looking for a new RDBMS (Relational Database Management System). Each … Read more >>
In this MariaDB tutorial, we will understand how to rename a table in MariaDB and look at several examples. MariaDB Rename Table Here, we’ll learn how to use the MariaDB rename table in this part, which is explained using syntax and examples. The ALTER TABLE statement in MariaDB is used to change, drop, or delete … Read more >>
In this MongoDB tutorial, we will discuss and learn more about how to sort by date in MongoDB and how we can sort by date differently. MongoDB sort by date A few days back, I was working on a blog page and recognized that the post was from old to the new order, which is not … Read more >>
This MariaDB tutorial will cover how to show tables in MariaDB. To help you better understand the topic, we will explore and conclude several situations in this section. How to show tables in MariaDB To show tables in MariaDB, we will use the SHOW TABLES statement in this section. The syntax is given below. Here is a … Read more >>
In this PostgreSQL tutorial, we will discuss, about PostgreSQL ADD COLUMN statement with 17 examples to add one or more columns to an existing table. PostgreSQL ADD COLUMN To add a new column to an existing table in PostgreSQL, you can use the ALTER TABLE ADD COLUMN statement. The syntax is as follows: In the above syntax, NOTE … Read more >>
In this MariaDB Tutorial, we are going to learn about Grant All Privileges MariaDB. Grant All Privileges MariaDB Before proceeding, you need to make sure, you have already created a database in MariaDB and created a user in the MariaDB database. Here, I have created a MariaDB database by using the following command: And also … Read more >>
In this MariaDB tutorial, we are going to learn about MariaDB Insert Into statement. If you do not have a table in your MariaDB database, then first create a table in MariaDB. MariaDB Insert Into In MariaDB, the INSERT command inserts data into a table. The syntax of the command is usually INSERT, followed by the table’s name, fields, and … Read more >>
In this MariaDB tutorial, we will discuss how to use the MariaDB Insert If Not Exists condition and look at several examples related to it. MariaDB Insert If Not Exists Here we will understand how to insert rows in the table if it does not exist in MariaDB. This is because when we have a … Read more >>
In this PostgreSQL tutorial, we are diving into the realm of database management by demonstrating how to install PostgreSQL on a Windows operating system. Download and Install PostgreSQL on Windows To download and install PostgreSQL on Windows, follow the below steps. Step 1: Download PostgreSQL From the official PostgreSQL website, first download the Windows installer. … Read more >>
In this PostgreSQL tutorial, we will learn about “Postgresql generate_series” which helps in generating series of numbers, dates, months and row numbers, etc. Postgresql generate_series In Postgresql, we use the generate_series() function to generate series of numbers. Use the below command to generate series of numbers: Syntax: Postgresql generate_series function accepts three parameters: Note: The … Read more >>