PostgreSQL
PostgreSQL INNER JOIN
PostgreSQL INNER JOIN An INNER JOIN is used to retrieve data from two tables where there is a match between the specified columns in both tables. O…
Filter
PostgreSQL
by
Soeng Souy
/
PostgreSQL LEFT JOIN
PostgreSQL LEFT JOIN A LEFT JOIN (or LEFT OUTER JOIN ) is used to return all rows from the left table (the first table in the join), and the matche…
PostgreSQL
by
Soeng Souy
/
PostgreSQL SELECT DISTINCT
PostgreSQL SELECT DISTINCT The SELECT DISTINCT statement in PostgreSQL is used to return unique (non-duplicate) values from a column or a set of co…
PostgreSQL
by
Soeng Souy
/
PostgreSQL WHERE
PostgreSQL WHERE Clause The WHERE clause in PostgreSQL is used to filter records from a table based on a specified condition. It is one of the mos…
PostgreSQL
by
Soeng Souy
/
PostgreSQL Sample Database
PostgreSQL Sample Database A sample database is useful for testing queries, learning SQL, and developing applications. Below, you'll find a step…
PostgreSQL
by
Soeng Souy
/
PostgreSQL LENGTH Function
PostgreSQL LENGTH Function The LENGTH function in PostgreSQL is used to determine the number of characters or bytes in a string. It is commonly us…
PostgreSQL
by
Soeng Souy
/
PostgreSQL CREATE TABLE
PostgreSQL CREATE TABLE Statement The CREATE TABLE statement in PostgreSQL is used to define a new table in a database. You must specify the table…
PostgreSQL
by
Soeng Souy
/
Connect To a PostgreSQL Database Server
How to Connect to a PostgreSQL Database Server You can connect to a PostgreSQL database using various methods: psql (Command Line) pgAdmin (Graphica…
PostgreSQL
by
Soeng Souy
/
PostgreSQL CONCAT Function
PostgreSQL CONCAT Function The CONCAT function in PostgreSQL is used to combine multiple strings into one . It automatically handles NULL values b…
PostgreSQL
by
Soeng Souy
/
PostgreSQL LIMIT
PostgreSQL LIMIT Clause The LIMIT The clause in PostgreSQL restricts the number of rows a query returns . This is useful for pagination , top N …
PostgreSQL
by
Soeng Souy
/
PostgreSQL SELECT
PostgreSQL SELECT Statement The SELECT statement in PostgreSQL is used to retrieve data from a table. You can filter, sort, group, and modify the d…
PostgreSQL
by
Soeng Souy
/
PostgreSQL ORDER BY
PostgreSQL ORDER BY Clause The ORDER BY clause in PostgreSQL is used to sort query results in either ascending (ASC) or descending (DESC) order.
PostgreSQL
by
Soeng Souy
/
PostgreSQL Data Types
PostgreSQL Data Types PostgreSQL provides a rich set of data types to store different kinds of data efficiently. Below is a categorized list of the …
PostgreSQL
by
Soeng Souy
/
PostgreSQL CREATE DATABASE
Step 1: Install PostgreSQL (If Not Installed) If you haven’t installed PostgreSQL yet, you need to install it first.
MySQL
by
Souy Soeng
/
MySQL INDEXES
MySQL INDEXES: A Comprehensive Guide What is an Index in MySQL? An index in MySQL is a data structure that improves the speed of data retrieval oper…
MySQL
by
Soeng Souy
/
Alter Stored Procedures
How to Alter Stored Procedures in MySQL MySQL does not provide a direct ALTER PROCEDURE statement. If you need to modify a stored procedure, you mu…
MySQL
by
Soeng Souy
/
MySQL CHECK Constraint Emulation
MySQL CHECK Constraint Emulation 1. What is the CHECK Constraint? The CHECK constraint is used to enforce a condition on column values in a table. …
MySQL
by
Soeng Souy
/
How To Use The MySQL Generated Columns
How To Use MySQL Generated Columns Introduction to Generated Columns in MySQL Generated columns in MySQL are special columns whose values are compute…
MySQL
by
Soeng Souy
/
MySQL INT Data Type
MySQL INT Data Type The INT (short for integer ) data type in MySQL is used to store whole numbers (i.e., numbers without decimal places). It is on…
MySQL
by
Soeng Souy
/
MySQL DECIMAL Data Type
MySQL DECIMAL Data Type The DECIMAL data type in MySQL is used to store exact numeric values with a specified precision and scale. It is especially…
MySQL
by
Soeng Souy
/
An Introduction to MySQL BOOLEAN Data Type
An Introduction to MySQL BOOLEAN Data Type MySQL does not have a native BOOLEAN data type , but it allows you to simulate BOOLEAN behavior using the…
MySQL
by
Soeng Souy
/
Pragmatic Uses of MySQL BIT Data Type
Pragmatic Uses of MySQL BIT Data Type The BIT data type in MySQL is used to store binary values efficiently. It is commonly used for storing flags,…
MySQL
by
Soeng Souy
/
MySQL CHAR Data Type
MySQL CHAR Data Type: A Complete Guide The CHAR data type in MySQL is used to store fixed-length character strings . Unlike VARCHAR , which stores v…
MySQL
by
Soeng Souy
/
The Essential Guide to MySQL VARCHAR Data Type
The Essential Guide to MySQL VARCHAR Data Type The VARCHAR data type in MySQL is used to store variable-length strings , making it ideal for storing…
MySQL
by
Soeng Souy
/
The Basics Of MySQL TEXT Data Type
The Basics of MySQL TEXT Data Type In MySQL, the TEXT data type is used to store large amounts of text-based data efficiently. It is commonly used f…
MySQL
by
Soeng Souy
/
The Ultimate Guide To MySQL DATE and Date Functions
The Ultimate Guide to MySQL DATE and Date Functions In MySQL, the DATE data type is used to store calendar dates (YYYY-MM-DD format). MySQL provide…
MySQL
by
Soeng Souy
/
Mastering MySQL TIME Data Type
Mastering MySQL TIME Data Type The TIME data type in MySQL is used to store time values (HH:MM:SS format) . It is useful for representing durations,…
MySQL
by
Soeng Souy
/
A Complete Guide To MySQL DATETIME Data Type
A Complete Guide to MySQL DATETIME Data Type The DATETIME data type in MySQL is used to store date and time values without timezone conversion. It …
MySQL
by
Soeng Souy
/
MySQL TIMESTAMP
MySQL TIMESTAMP Data Type The TIMESTAMP data type in MySQL is used to store date and time values . It is commonly used for tracking changes in recor…
MySQL
by
Soeng Souy
/
A Practical Guide to MySQL JSON Data Type By Example
A Practical Guide to MySQL JSON Data Type By Example The JSON data type in MySQL allows you to store and manipulate structured JSON data inside a d…
