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.
MySQL Query to Extract WordPress Posts with Featured Thumbnails

MySQL Query to Extract WordPress Posts with Featured Thumbnails

5
Comments
3 min read
Free SQL Tool to Understand Your Database Visually

Free SQL Tool to Understand Your Database Visually

7
Comments
3 min read
🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)

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

1
Comments
1 min read
Getting Started with Databases: SQL & MySQL

Getting Started with Databases: SQL & MySQL

1
Comments
9 min read
How to Duplicate a Table in MySQL

How to Duplicate a Table in MySQL

Comments 1
2 min read
Mastering RESTful API Integration: Your Guide to Seamless Connections

Mastering RESTful API Integration: Your Guide to Seamless Connections

1
Comments
4 min read
5 key MySQL metrics every DBA should track

5 key MySQL metrics every DBA should track

Comments
3 min read
Handling NULL Values in SQL: Best Practices and Common Pitfalls

Handling NULL Values in SQL: Best Practices and Common Pitfalls

2
Comments
5 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
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
Mastering Dynamic SQL Operations with the Strategy Pattern: Generate and Execute Commands Across Databases in C#

Mastering Dynamic SQL Operations with the Strategy Pattern: Generate and Execute Commands Across Databases in C#

6
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
5 SQL Join Mistakes I Made as a Learner (and How I Fixed Them)"

5 SQL Join Mistakes I Made as a Learner (and How I Fixed Them)"

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

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Comments
2 min read
Como Executar sua Aplicação Spring Boot no Kubernetes com Banco MySQL

Como Executar sua Aplicação Spring Boot no Kubernetes com Banco MySQL

1
Comments
8 min read
Mixed-Source Computing:SPL Practices

Mixed-Source Computing:SPL Practices

7
Comments
9 min read
ServBay for Windows 1.4.0 Released: Adds Custom Configuration for MySQL and Other Databases

ServBay for Windows 1.4.0 Released: Adds Custom Configuration for MySQL and Other Databases

Comments
3 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
Implementing the Outbox Pattern with MySQL and using Brighter

Implementing the Outbox Pattern with MySQL and using Brighter

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
What is the `DECIMAL` type in MySQL?

What is the `DECIMAL` type in MySQL?

Comments
1 min read
Database Design Errors to Avoid & How To Fix Them

Database Design Errors to Avoid & How To Fix Them

11
Comments 1
5 min read
loading...