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.
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
RDS Blue/Green Deployments while using IaC

RDS Blue/Green Deployments while using IaC

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

Postgres on a Budget: 3 Free Solutions You Should Know

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

SQL ORDER BY: Quick Sorting Examples and Tips

Comments 1
2 min read
MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

MySQL Database: Hands-On Labs for Multi-Table Operations & Sales Data Analysis

Comments
2 min read
Mixed-Source Computing:SPL Practices

Mixed-Source Computing:SPL Practices

7
Comments
9 min read
DigitalOcean Fundamentals: MySQL

DigitalOcean Fundamentals: MySQL

Comments
9 min read
How to Load Data From MySQL to Iceberg in Real Time

How to Load Data From MySQL to Iceberg in Real Time

1
Comments
5 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 1
4 min read
Fastest way to import excel into mysql

Fastest way to import excel into mysql

Comments
2 min read
SQL JOINS

SQL JOINS

Comments 1
3 min read
Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

8
Comments
3 min read
I Made a Java Chat App in One Night (Because I Had No Projects)

I Made a Java Chat App in One Night (Because I Had No Projects)

5
Comments
2 min read
Features I Wish Postgres 🐘 Had but MySQL 🐬 Already Has 😼

Features I Wish Postgres 🐘 Had but MySQL 🐬 Already Has 😼

6
Comments
4 min read
How to import excel into mysql only 1 step

How to import excel into mysql only 1 step

Comments
2 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

2
Comments 2
1 min read
DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

DBMS vs. RDBMS: Concepts, Differences, and Real-World Applications

Comments
3 min read
The Seven Types of Locks in InnoDB

The Seven Types of Locks in InnoDB

Comments
5 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
Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

5
Comments
7 min read
MySQL — Removendo Full Only Group By no MacOS X

MySQL — Removendo Full Only Group By no MacOS X

Comments 1
1 min read
🚀 Laravel Migration Generator – Now with PostgreSQL and MSSQL Support

🚀 Laravel Migration Generator – Now with PostgreSQL and MSSQL Support

Comments
1 min read
MySQL Tutorial for Beginners: Learn SQL with Practical Examples

MySQL Tutorial for Beginners: Learn SQL with Practical Examples

Comments
3 min read
Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

1
Comments
5 min read
How to import Excel to MySQL

How to import Excel to MySQL

Comments
2 min read
loading...