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.
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
Safe Database Migration: Converting MySQL Enum to String in Laravel

Safe Database Migration: Converting MySQL Enum to String in Laravel

Comments
3 min read
Simplify Data Migration Between Databases Using DbVisualizer

Simplify Data Migration Between Databases Using DbVisualizer

Comments
1 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
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

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

29
Comments 4
4 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
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

7
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?

5
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

4
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

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