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.
A simple tool for automated MySQL database dumps and restores

A simple tool for automated MySQL database dumps and restores

2
Comments 2
1 min read
Top 8 MySQL Schema Checks to Boost Database Performance

Top 8 MySQL Schema Checks to Boost Database Performance

1
Comments
7 min read
How to Document Your Database with a GUI Tool

How to Document Your Database with a GUI Tool

8
Comments 4
8 min read
MySQL Terminal: Add and delete column

MySQL Terminal: Add and delete column

Comments
2 min read
MySQL Terminal: Alter table, charset and delete

MySQL Terminal: Alter table, charset and delete

Comments
3 min read
SQL 耗时跟踪

SQL 耗时跟踪

Comments
4 min read
How to Fix MySQL Not Running on macOS Sequoia 15.0

How to Fix MySQL Not Running on macOS Sequoia 15.0

6
Comments 2
1 min read
💻 Common MySQL Commands 🐬

💻 Common MySQL Commands 🐬

Comments
8 min read
Optimizing Sorting and Filtering on JSON Columns in Laravel with Indexed Virtual Columns

Optimizing Sorting and Filtering on JSON Columns in Laravel with Indexed Virtual Columns

Comments
5 min read
Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Comments 2
7 min read
📂 Building a Simple File Management System with PHP & MySQL 🚀

📂 Building a Simple File Management System with PHP & MySQL 🚀

18
Comments
3 min read
Query Optimization in MySQL: Optimizing Top Queries vs. Slow Queries

Query Optimization in MySQL: Optimizing Top Queries vs. Slow Queries

8
Comments
4 min read
⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

10
Comments
10 min read
What Is a NoSQL Database and When Should You Use It?

What Is a NoSQL Database and When Should You Use It?

7
Comments 4
6 min read
mysql: “thai food near me”, or: doing geo distance calculations in your database.

mysql: “thai food near me”, or: doing geo distance calculations in your database.

1
Comments
13 min read
🔥Must Notes When Using Open Sources 🧩

🔥Must Notes When Using Open Sources 🧩

2
Comments
4 min read
Adding a Serial ID to MySQL Tables Based on Creation Date: A Step-by-Step Guide

Adding a Serial ID to MySQL Tables Based on Creation Date: A Step-by-Step Guide

1
Comments
3 min read
Mastering MySQL Performance: What It MySQL Latency and Why It Matters

Mastering MySQL Performance: What It MySQL Latency and Why It Matters

Comments
4 min read
🛠️ DB Migration For Golang Services, Why it matters? 🐹

🛠️ DB Migration For Golang Services, Why it matters? 🐹

2
Comments 1
8 min read
Migrating to Amazon RDS

Migrating to Amazon RDS

5
Comments
6 min read
Simple Ways to Identify the MySQL Port

Simple Ways to Identify the MySQL Port

2
Comments
2 min read
Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'

Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'

Comments
3 min read
Unlocking speed: the power of indexing in database performance

Unlocking speed: the power of indexing in database performance

4
Comments
4 min read
Mastering MySQL Performance: A Guide to Slow Query Monitoring

Mastering MySQL Performance: A Guide to Slow Query Monitoring

Comments
4 min read
Upsert a row in a DB that doesn't use primary keys or unique constraints

Upsert a row in a DB that doesn't use primary keys or unique constraints

2
Comments
3 min read
loading...