Skip to content
Mysql Logo
  • Home
  • About
  • Team
  • Contact
  • MySQL

All About MySQL.

Renaming Tables in PostgreSQL: A Step-by-Step Guide

In this tutorial, we will learn how can we rename the table using the RENAME command. We have to use the RENAME keyword with the ALTER TABLE statement to make it work. So, let’s see how it is done! PostgreSQL RENAME Table Statement First of all, the RENAME keyword cannot be used standalone to rename …

Renaming Tables in PostgreSQL: A Step-by-Step Guide Read More »

How to Add Columns to a Table in PostgreSQL

In this tutorial, we will be learning to add single or multiple columns in PostgreSQL. This is going to be a very simple tutorial where we will use the ALTER TABLE statement with the ADD COLUMN statement. So, let’s get started! ADD COLUMN Statement in PostgreSQL In PostgreSQL, the ADD COLUMN statement is used with …

How to Add Columns to a Table in PostgreSQL Read More »

PostgreSQL UPDATE Join: Introduction, Syntax & Example

In this tutorial, we will be learning about one of the coolest features of PostgreSQL which is UPDATE join. When you want to update the value of a certain table based on a value in another table, you use the UPDATE join. This is a very interesting topic, so let’s get started without wasting time! …

PostgreSQL UPDATE Join: Introduction, Syntax & Example Read More »

PostgreSQL ALTER TABLE (With Examples)

In some cases, you want to modify the table structure but not the table data. In this case, you use the ALTER TABLE command. In this tutorial, we will go through all the important key points of the ALTER TABLE statement. So, let’s get started! Also Read: PostgreSQL – A Complete Introduction, History, and Features …

PostgreSQL ALTER TABLE (With Examples) Read More »

Upsert Operation in PostgreSQL using INSERT ON CONFLICT

In this tutorial, we will learn about the INSERT ON CONFLICT statement which is used to perform the upsert operation. If you don’t know what is the upsert operation, don’t worry, we will cover everything in this tutorial. So without further wasting time, let’s get started! Also Read: PostgreSQL – A Complete Introduction, History, and …

Upsert Operation in PostgreSQL using INSERT ON CONFLICT Read More »

PostgreSQL DELETE Statement: Removing Rows from Table

In this tutorial, we will learn about the DELETE statement in PostgreSQL with examples. The delete statement is used to delete the table records. Let’s see the DELETE statement in depth. Also Read: PostgreSQL – A Complete Introduction, History, and Features Introduction to DELETE in PostgreSQL The DELETE statement in SQL is used to delete …

PostgreSQL DELETE Statement: Removing Rows from Table Read More »

5 SQL Functions for String Manipulation (With Examples)

SQL is used to manage data in relational databases. While it is most commonly associated with querying databases, SQL offers much more through its versatile functions that enable efficient data analysis and manipulation. A significant amount of raw data is in text form, so having versatile methods for manipulating strings is very important. Raw data is …

5 SQL Functions for String Manipulation (With Examples) Read More »

PostgreSQL Column Alias (With Examples)

Sometimes you need to display a different name for the column of a table than the original one. In this case, you can use the alias for that column. In this tutorial, we will learn how we can use the column aliases in PostgreSQL. So, let’s get started! Introduction to Column Alias in PostgreSQL A …

PostgreSQL Column Alias (With Examples) Read More »

PostgreSQL UPDATE: Introduction, Syntax & Examples

The UPDATE statement is used to update or modify the existing data in the table on a certain condition. In this tutorial, we will be learning the UPDATE statement in PostgreSQL with some other important points related to it. So, let’s get started! Introduction to UPDATE Statement in PostgreSQL The UPDATE statement can be used …

PostgreSQL UPDATE: Introduction, Syntax & Examples Read More »

PostgreSQL SELECT DISTINCT Clause: Introduction, Syntax & Examples

There is a probability that you would need to fetch only unique rows from the table. That is where the DISTINCT clause comes into action. In this tutorial, we will learn how can we use the PostgreSQL DISTINCT clause in multiple ways to fetch unique records. So, let’s get started! Also Read: How to Create …

PostgreSQL SELECT DISTINCT Clause: Introduction, Syntax & Examples Read More »

Posts navigation
← Previous Page 1 2 3 4 … 42 Next Page →

Recent Posts

  • How To Convert SQL Subquery To Join?
  • Performing Calculations On Date-Time Related Values
  • PostgreSQL IS NULL and IS NOT NULL Operators
  • PostgreSQL UNIQUE Constraint: Introduction, Syntax & Examples
  • PostgreSQL Primary Key Constraint (With Examples)
  • PostgreSQL LIKE Operator: Query Data Using Pattern Matching
  • PostgreSQL IN Operator: Filtering Data Using Multiple Values
  • PostgreSQL BETWEEN Operator: Query Data Within Specified Range
  • PostgreSQL FETCH Clause: Introduction, Syntax & Examples
  • PostgreSQL: A Guide to LIMIT and OFFSET With Examples
  • MySQL Find Duplicate Values in Table: A Detailed Guide
  • SQL Self Join: Everything You Need to Know
  • SQL Outer Join: LEFT, RIGHT & FULL With Examples
  • PostgreSQL TRUNCATE TABLE: Syntax, Examples & Limitations
  • PostgreSQL WHERE Clause: Introduction, Syntax & Examples

Favorite Sites

  • Python Tutorials
  • Linux Tutorials
  • GoLang Tutorials
  • CodeForGeek
  • VM-Help
Copyright © 2023 MySQLCode · All Rights Reserved
Privacy Policy · Terms and Conditions · Contact · About
MySQLCode.com is part of JournalDev IT Services Private Limited