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.
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Comments
5 min read
MySQL Not Responding? A Simple Guide to Diagnosing and Fixing It

MySQL Not Responding? A Simple Guide to Diagnosing and Fixing It

Comments
6 min read
Simplify Data Migration Between Databases Using DbVisualizer

Simplify Data Migration Between Databases Using DbVisualizer

Comments
1 min read
Safe Database Migration: Converting MySQL Enum to String in Laravel

Safe Database Migration: Converting MySQL Enum to String in Laravel

Comments 1
3 min read
Fixing the 'MySQL Module Shutting Down Unexpectedly' Error in XAMPP: Step-by-Step Guide

Fixing the 'MySQL Module Shutting Down Unexpectedly' Error in XAMPP: Step-by-Step Guide

1
Comments
2 min read
Quick Guide to MySQL Math Functions for SQL Users

Quick Guide to MySQL Math Functions for SQL Users

Comments
2 min read
How to Fix "MySQL Shutdown Unexpectedly"

How to Fix "MySQL Shutdown Unexpectedly"

1
Comments
2 min read
Ethical Hacking: Safeguarding the Digital Frontier💻🔓🛡️

Ethical Hacking: Safeguarding the Digital Frontier💻🔓🛡️

1
Comments
3 min read
ROLLUP

ROLLUP

Comments
2 min read
Create a Relational Database Application

Create a Relational Database Application

5
Comments
3 min read
decenphp1.4

decenphp1.4

Comments
2 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

Comments
2 min read
Connect MySQL Workbench to MySQL Server in WSL using Node

Connect MySQL Workbench to MySQL Server in WSL using Node

Comments
1 min read
How to use variables in SQL raiserror

How to use variables in SQL raiserror

Comments
1 min read
Database Normalization

Database Normalization

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

MySQL Terminal: Add and delete column

Comments
2 min read
Mastering MySQL Views

Mastering MySQL Views

Comments
6 min read
MySQL Numeric Data Types Explained

MySQL Numeric Data Types Explained

Comments
2 min read
PostgreSQL vs. MySQL

PostgreSQL vs. MySQL

2
Comments
1 min read
💻 Common MySQL Commands 🐬

💻 Common MySQL Commands 🐬

Comments
8 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
MySQL Daemon Overview and Tools

MySQL Daemon Overview and Tools

Comments
1 min read
Building a Bible Publication Engine

Building a Bible Publication Engine

1
Comments
2 min read
Essential MySQL Operators and Their Applications

Essential MySQL Operators and Their Applications

Comments
2 min read
Running MySQL Server in Docker

Running MySQL Server in Docker

Comments
1 min read
Connecting to a MySQL Database in PHP

Connecting to a MySQL Database in PHP

Comments
4 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
Simple Ways to Identify the MySQL Port

Simple Ways to Identify the MySQL Port

1
Comments
2 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

30
Comments 5
4 min read
MySQL Terminal: Alter table, charset and delete

MySQL Terminal: Alter table, charset and delete

Comments
3 min read
Best Practices for Handling Sensitive Data in MySQL Databases

Best Practices for Handling Sensitive Data in MySQL Databases

Comments 1
4 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

25
Comments 8
13 min read
How to FIX: Error: MySQL shutdown unexpectedly

How to FIX: Error: MySQL shutdown unexpectedly

Comments
1 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
Boost Your MySQL Debugging Skills with the General Query Log

Boost Your MySQL Debugging Skills with the General Query Log

Comments
4 min read
How to choose the right database?

How to choose the right database?

Comments
4 min read
Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

12
Comments
1 min read
🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

Comments
2 min read
🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

Comments
2 min read
🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

Comments
2 min read
🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

🚧 Desarrollo de Rappy Minimarket: Un E-commerce en Construcción 🛠️

Comments
2 min read
Automated CSV and Excel Data Import to MySQL and PostgreSQL Databases Using PHP

Automated CSV and Excel Data Import to MySQL and PostgreSQL Databases Using PHP

6
Comments
2 min read
Apache Log Parser and Data Normalization Application

Apache Log Parser and Data Normalization Application

Comments
1 min read
Setting Up MySQL on Kubernetes with Prometheus & Grafana Monitoring

Setting Up MySQL on Kubernetes with Prometheus & Grafana Monitoring

8
Comments 1
4 min read
Learning PHP and MySQL—Is Laravel the Next Step?

Learning PHP and MySQL—Is Laravel the Next Step?

3
Comments 1
1 min read
How to Set Up MariaDB/MySQL Exporter on Galera Cluster Nodes for Prometheus Monitoring

How to Set Up MariaDB/MySQL Exporter on Galera Cluster Nodes for Prometheus Monitoring

Comments
3 min read
How to Move Data From MySQL to Redis in Real Time

How to Move Data From MySQL to Redis in Real Time

3
Comments
3 min read
Step-by-Step Guide: Querying From Databases Via a Single Database Helper Using the Strategy Design Pattern

Step-by-Step Guide: Querying From Databases Via a Single Database Helper Using the Strategy Design Pattern

3
Comments
3 min read
PHP/MySQL/Nginx/Redis Application Docker

PHP/MySQL/Nginx/Redis Application Docker

1
Comments
1 min read
Creating a Remote Git Hub for Your Company(Without Github)

Creating a Remote Git Hub for Your Company(Without Github)

10
Comments 3
3 min read
A simple tool for automated MySQL database dumps and restores

A simple tool for automated MySQL database dumps and restores

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

Top 8 MySQL Schema Checks to Boost Database Performance

3
Comments
7 min read
SQL ain't that Scary

SQL ain't that Scary

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

How to Document Your Database with a GUI Tool

Comments 3
8 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

2
Comments 2
1 min read
How to Set Up MySQL to Autostart on macOS: A Step-by-Step Guide for Developers

How to Set Up MySQL to Autostart on macOS: A Step-by-Step Guide for Developers

Comments
3 min read
MySQL Basics: Understanding Isolation Level and Transaction Anomalies

MySQL Basics: Understanding Isolation Level and Transaction Anomalies

Comments
4 min read
MySQL Basics: Understanding Join and Index with Examples

MySQL Basics: Understanding Join and Index with Examples

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