DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)

🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)

1
Comments
1 min read
Migrating from MySQL 8 to PostgreSQL 17 on Ubuntu 24.04 LTS

Migrating from MySQL 8 to PostgreSQL 17 on Ubuntu 24.04 LTS

Comments
3 min read
Postgres on a Budget: 3 Free Solutions You Should Know

Postgres on a Budget: 3 Free Solutions You Should Know

Comments
2 min read
5 key MySQL metrics every DBA should track

5 key MySQL metrics every DBA should track

Comments
3 min read
May 2025 at Releem: Configuration History for MySQL & MariaDB

May 2025 at Releem: Configuration History for MySQL & MariaDB

5
Comments
2 min read
RDS Blue/Green Deployments while using IaC

RDS Blue/Green Deployments while using IaC

4
Comments
10 min read
How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

How to Add and Subtract Dates in SQL (MySQL, PostgreSQL, SQL Server)

Comments
2 min read
Laravel 12 Webcam Capture Image and Save from Webcam & display with MySQL Database

Laravel 12 Webcam Capture Image and Save from Webcam & display with MySQL Database

Comments
4 min read
Essential SQL Commands for Developers (With Code Samples)

Essential SQL Commands for Developers (With Code Samples)

Comments
2 min read
MySQL Basic Knowledge Points

MySQL Basic Knowledge Points

Comments
2 min read
MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

Comments
3 min read
🚀 Migrating from SQLite3 to MySQL in My Django REST API – Step by Step

🚀 Migrating from SQLite3 to MySQL in My Django REST API – Step by Step

Comments
1 min read
Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Comments
2 min read
MySQL Point-in-Time Recovery (PITR) Using Percona XtraBackup and Binary Logs from a Full Backup Across Two Linux Servers

MySQL Point-in-Time Recovery (PITR) Using Percona XtraBackup and Binary Logs from a Full Backup Across Two Linux Servers

Comments
4 min read
Mixed-Source Computing:SPL Practices

Mixed-Source Computing:SPL Practices

7
Comments
9 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

6
Comments
5 min read
Implementando o padrĂŁo Outbox Pattern com MySQL e usando Brighter

Implementando o padrĂŁo Outbox Pattern com MySQL e usando Brighter

Comments
5 min read
Implementing the Outbox Pattern with MySQL and using Brighter

Implementing the Outbox Pattern with MySQL and using Brighter

Comments
5 min read
What is the `DECIMAL` type in MySQL?

What is the `DECIMAL` type in MySQL?

Comments
1 min read
HANDLING THE SAFE UPDATE MODE IN MYSQL

HANDLING THE SAFE UPDATE MODE IN MYSQL

Comments
1 min read
How to Seamlessly Integrate SeaTunnel MySQL-CDC with Databend: Formats Explained & Best Practices

How to Seamlessly Integrate SeaTunnel MySQL-CDC with Databend: Formats Explained & Best Practices

Comments 1
10 min read
MySQL Tutorial: A Complete Guide to Mastering Database Management

MySQL Tutorial: A Complete Guide to Mastering Database Management

1
Comments
3 min read
INTERVAL com MySQL

INTERVAL com MySQL

Comments
1 min read
How to Speed Up Conditional Filtering on Enumerated Fields with esProc

How to Speed Up Conditional Filtering on Enumerated Fields with esProc

7
Comments
6 min read
Mastering Foreign Keys in MySQL: A Comprehensive Guide

Mastering Foreign Keys in MySQL: A Comprehensive Guide

Comments
6 min read
loading...