MySQL

290+ posts

Last Updated: 23 March 2026

The ALTER TABLE statement in MySQL is used to modify the structure of an existing table without deleting or recreating it. It helps update database tables efficiently as r...read more

mysql

MySQL

MySQL Data Types

Last Updated: 19 March 2026

MySQL Data Types define the type of data that can be stored in a table column. They help ensure that data is stored in a structured and efficient way.Ensure that only vali...read more

mysql

MySQL

MySQL Query

Setting Up Gorm With MySQL

Last Updated: 23 July 2025

In this article, we’ll set up GORM, an ORM library, with MySQL using the Gin web framework in Go. GORM provides features that make database interactions easier by allowing...read more

Last Updated: 23 July 2025

In MySQL, triggers automatically perform actions when events like INSERT, UPDATE, or DELETE occur on a table However, there are situations where a trigger may not be neces...read more

Picked

Databases

MySQL

DATETIME vs TIMESTAMP Data Type in MySQL?

Last Updated: 23 July 2025

When designing a database schema in MySQL, choosing the appropriate data type for storing date and time information is important. MySQL offers two primary data types for t...read more

Databases

MySQL

MySQL - CHECKSUM TABLE Statement

Last Updated: 23 July 2025

The CHECKSUM TABLE statement in MySQL is a useful tool to verify the integrity of tables and detect any changes or corruption in the data stored within them. This statemen...read more

Databases

MySQL

MySQL Window Functions

Last Updated: 18 August 2026

MySQL Window Functions perform calculations across a set of rows related to the current row without grouping or collapsing the result. Can divide rows into groups using PA...read more

Picked

Databases

MySQL

When to Use "ON UPDATE CASCADE" in MySQL

Last Updated: 23 July 2025

In MySQL, the ON UPDATE CASCADE option in foreign key constraints indicates that anytime an update is made to a row in the parent table, matching rows in child tables are ...read more

Last Updated: 19 August 2026

A cursor in MySQL is used to process the rows returned by a query one row at a time. Cursors are mainly used inside stored procedures and stored functions when we need to ...read more

Picked

Databases

MySQL

MySQL BEFORE DELETE Trigger

Last Updated: 23 July 2025

MySQL BEFORE DELETE trigger is a powerful tool that automatically performs specific actions before an DELETE operation is executed on a table. This feature allows us to ha...read more

Picked

Databases

MySQL

Foreign Key with a Null Value in MySQL

Last Updated: 23 July 2025

In databases, foreign keys are like links connecting two tables. They make sure that data in one table matches data in another. But a common question is whether a foreign ...read more

Picked

Databases

MySQL

MySQL Before Insert Trigger

Last Updated: 23 July 2025

MySQL BEFORE INSERT triggers are essential tools for maintaining data quality and enforcing business rules at the database level. These triggers automatically execute a se...read more

Last Updated: 13 August 2026

MySQL provides the JOIN clause to combine rows from two or more tables based on a related column. It is useful for retrieving related data from multiple tables in a single...read more

Last Updated: 23 July 2025

SHOW TRIGGERS is the MySQL way of showing all the registered database triggers for a given database. Triggers are special kinds of rules that perform predefined actions on...read more

Picked

Databases

MySQL

MySQL After Insert Trigger

Last Updated: 23 July 2025

An "AFTER INSERT" trigger in MySQL automatically executes specified actions after a new row is inserted into a table. It is used to perform tasks such as updating related ...read more

Picked

Databases

MySQL

1 2 3 4

...