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.
SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System

SQL IQ – Advanced SQL Interview Queries Search and Prep System

1
Comments
4 min read
How to Solve MySQL and Redis Cache Inconsistency Like a Pro

How to Solve MySQL and Redis Cache Inconsistency Like a Pro

7
Comments
2 min read
Implementing Transactional Tests with MySQL

Implementing Transactional Tests with MySQL

Comments
6 min read
MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

1
Comments
10 min read
What is Error Code 1451 in MySQL

What is Error Code 1451 in MySQL

Comments
1 min read
Integrating Python with MySQL Databases: An Introduction and Practical Guide

Integrating Python with MySQL Databases: An Introduction and Practical Guide

Comments
12 min read
SQL DATABASE

SQL DATABASE

Comments
1 min read
SQL Tricks: Generate Calendar Table

SQL Tricks: Generate Calendar Table

Comments
5 min read
How to Count Daily Records with MySQL

How to Count Daily Records with MySQL

Comments
1 min read
How to Duplicate Rows in MySQL

How to Duplicate Rows in MySQL

Comments
2 min read
Building an Accessible School Management Portal: Lessons from My Web Dev Journey

Building an Accessible School Management Portal: Lessons from My Web Dev Journey

Comments
2 min read
MySQL 5.7 - 8.0 on Google CloudSQL: Inplace Migration

MySQL 5.7 - 8.0 on Google CloudSQL: Inplace Migration

Comments
6 min read
MySQL Data Synchronization to S3file and Hive Access: A SeaTunnel Practical Guide

MySQL Data Synchronization to S3file and Hive Access: A SeaTunnel Practical Guide

Comments
3 min read
Why Graph Databases Like Neo4j Are the Future of AI Data Modeling

Why Graph Databases Like Neo4j Are the Future of AI Data Modeling

Comments
2 min read
Visualize Data with Amazon QuickSight

Visualize Data with Amazon QuickSight

Comments
2 min read
🛠️ 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
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
SQL ORDER BY: Quick Sorting Examples and Tips

SQL ORDER BY: Quick Sorting Examples and Tips

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