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.
Entendo a ordem de execução de uma query SQL

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

1
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

5
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

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

Learning PHP and MySQL—Is Laravel the Next Step?

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

6
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

1
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

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

Top 8 MySQL Schema Checks to Boost Database Performance

2
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

4
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

4
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 Join and Index with Examples

MySQL Basics: Understanding Join and Index with Examples

Comments
5 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 🚀

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

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

9
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 🔥

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

1
Comments
8 min read
Migrating to Amazon RDS

Migrating to Amazon RDS

5
Comments
6 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

3
Comments
3 min read
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

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

Comments
2 min read
How to FIX: Error: MySQL shutdown unexpectedly

How to FIX: Error: MySQL shutdown unexpectedly

Comments 1
1 min read
🧪 GOLANG INTEGRATION TEST WITH GIN, GORM, TESTIFY, MYSQL

🧪 GOLANG INTEGRATION TEST WITH GIN, GORM, TESTIFY, MYSQL

4
Comments
5 min read
📝 30 COMMON MYSQL INTERVIEW QUESTIONS 🐬

📝 30 COMMON MYSQL INTERVIEW QUESTIONS 🐬

Comments
5 min read
Choosing the Right Primary Key for the Database

Choosing the Right Primary Key for the Database

1
Comments
6 min read
MySQL Terminal: Login, Users and Permissions

MySQL Terminal: Login, Users and Permissions

Comments
2 min read
Build a CDC Pipeline from MySQL to ClickHouse with BladePipe

Build a CDC Pipeline from MySQL to ClickHouse with BladePipe

2
Comments
3 min read
Protect Your Data: How to Create Unhackable SQL and MySQL Database Copies

Protect Your Data: How to Create Unhackable SQL and MySQL Database Copies

1
Comments
3 min read
MariaDB vs MySQL: What Developers Need to Know

MariaDB vs MySQL: What Developers Need to Know

Comments
1 min read
Creating a CRUD Application with PHP, MySQL, and Lithe

Creating a CRUD Application with PHP, MySQL, and Lithe

6
Comments 4
5 min read
Create a Booking Database In 3 Steps

Create a Booking Database In 3 Steps

Comments
17 min read
Criando uma Aplicação CRUD com PHP, MySQL e Lithe

Criando uma Aplicação CRUD com PHP, MySQL e Lithe

7
Comments 2
6 min read
Tutorial Install MySQL / MariaDB di Linux Ubuntu

Tutorial Install MySQL / MariaDB di Linux Ubuntu

Comments
2 min read
MySQL Optimize Tips

MySQL Optimize Tips

1
Comments
3 min read
Optimizing SQL Queries

Optimizing SQL Queries

2
Comments
5 min read
Essential Guide to MySQL Subqueries

Essential Guide to MySQL Subqueries

Comments
1 min read
SQL || MySQL || By Munisekhar Udavalapati

SQL || MySQL || By Munisekhar Udavalapati

1
Comments
2 min read
Building a Simple CRUD Application with PHP and MySQL

Building a Simple CRUD Application with PHP and MySQL

10
Comments 5
3 min read
SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL

SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL

1
Comments 4
1 min read
50x Faster Window Functions? PawSQL's Index Magic Revealed

50x Faster Window Functions? PawSQL's Index Magic Revealed

Comments
3 min read
Mastering MySQL Aggregate Functions: Simplifying Data Analysis

Mastering MySQL Aggregate Functions: Simplifying Data Analysis

Comments
4 min read
Why MySQL is the Superior Choice for Database Management Over MS Access

Why MySQL is the Superior Choice for Database Management Over MS Access

Comments 1
6 min read
Xampp MY-SQL running out 😐

Xampp MY-SQL running out 😐

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

How to import excel into mysql only 1 step

Comments
2 min read
loading...