Forem

# 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
Cover image for 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
Cover image for How to Document Your Database with a GUI Tool

How to Document Your Database with a GUI Tool

9
Comments 4
8 min read
MySQL Terminal: Add and delete column
Cover image for MySQL Terminal: Add and delete column

MySQL Terminal: Add and delete column

Comments
2 min read
MySQL Terminal: Alter table, charset and delete
Cover image for 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 🐬
Cover image for 💻 Common MySQL Commands 🐬

💻 Common MySQL Commands 🐬

Comments
8 min read
Optimizing Sorting and Filtering on JSON Columns in Laravel with Indexed Virtual Columns
Cover image for 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)
Cover image for 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 🚀
Cover image for 📂 Building a Simple File Management System with PHP & MySQL 🚀

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

22
Comments
3 min read
Query Optimization in MySQL: Optimizing Top Queries vs. Slow Queries
Cover image for 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 🔥
Cover image for ⚡ 🚀 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
🔥Must Notes When Using Open Sources 🧩
Cover image for 🔥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
Cover image for 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? 🐹
Cover image for 🛠️ 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
Cover image for 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'
Cover image for 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
Cover image for Unlocking speed: the power of indexing in database performance

Unlocking speed: the power of indexing in database performance

4
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

3
Comments
3 min read
MySQL Terminal: Create Databases, Tables and more.
Cover image for MySQL Terminal: Create Databases, Tables and more.

MySQL Terminal: Create Databases, Tables and more.

Comments
3 min read
Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval
Cover image for Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

Comments
2 min read
loading...