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.
🛠️ Como Recuperar um Banco de Dados MySQL/MariaDB Usando .ibd e .frm no XAMPP

🛠️ Como Recuperar um Banco de Dados MySQL/MariaDB Usando .ibd e .frm no XAMPP

Comments
4 min read
What is SQL? A Beginner's Complete Guide

What is SQL? A Beginner's Complete Guide

1
Comments
7 min read
Using CASE to Sort ENUM Values in MySQL

Using CASE to Sort ENUM Values in MySQL

1
Comments
2 min read
Spring Boot Login, Register, Logout with MySQL & Thymeleaf | Bootstrap UI | Show User Details

Spring Boot Login, Register, Logout with MySQL & Thymeleaf | Bootstrap UI | Show User Details

Comments
5 min read
Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.

Tired of Writing SQL Just to Explore Your DB? Me too. So I Built This.

1
Comments
2 min read
SQL ORDER BY: Quick Sorting Examples and Tips

SQL ORDER BY: Quick Sorting Examples and Tips

Comments
2 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
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
Getting Started with Databases: SQL & MySQL

Getting Started with Databases: SQL & MySQL

1
Comments
9 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
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
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
Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

Comments
2 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
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
loading...