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.
Explain the concept of an aggregate function in SQL. Provide examples of aggregate functions.

Explain the concept of an aggregate function in SQL. Provide examples of aggregate functions.

2
Comments
1 min read
Indexing JSON Data in MySQL 🐬

Indexing JSON Data in MySQL 🐬

1
Comments
2 min read
Integration Test MySQL with testcontainers-dotnet

Integration Test MySQL with testcontainers-dotnet

Comments
5 min read
Changes in procedures/functions while migrating from MySQL to PostgreSQL

Changes in procedures/functions while migrating from MySQL to PostgreSQL

3
Comments
3 min read
Unveiling the Mystery: How the `DESCRIBE` Command Can Bring Down a Server

Unveiling the Mystery: How the `DESCRIBE` Command Can Bring Down a Server

5
Comments
3 min read
Storing IP Addresses as Numbers in Your Database

Storing IP Addresses as Numbers in Your Database

5
Comments
2 min read
Resetting MySQL Root Password in Ubuntu: A Step-by-Step Guide

Resetting MySQL Root Password in Ubuntu: A Step-by-Step Guide

2
Comments
2 min read
Zabbix Server Kurulumu

Zabbix Server Kurulumu

2
Comments
2 min read
Integration Testing MySQL Store

Integration Testing MySQL Store

3
Comments
10 min read
Use a Stored Column for Indexing Values Stored in JSON [MySQL Tip]

Use a Stored Column for Indexing Values Stored in JSON [MySQL Tip]

5
Comments
2 min read
Amazon Aurora is Now 60 Times Faster than RDS for MySQL. Really.

Amazon Aurora is Now 60 Times Faster than RDS for MySQL. Really.

10
Comments
2 min read
Deploy a Ghost Blog in Production to Koyeb

Deploy a Ghost Blog in Production to Koyeb

Comments
8 min read
Simple OTP In PHP MYSQL

Simple OTP In PHP MYSQL

17
Comments 1
4 min read
Apache APISIX without etcd

Apache APISIX without etcd

22
Comments 5
5 min read
Cursor pagination for PostgreSQL/MySQL

Cursor pagination for PostgreSQL/MySQL

8
Comments
4 min read
Setting Up a LAMP Stack Application

Setting Up a LAMP Stack Application

4
Comments
13 min read
Scale up: a MySQL bug story, or why Aiven works

Scale up: a MySQL bug story, or why Aiven works

Comments
5 min read
MySQL usar tipo SET para validar

MySQL usar tipo SET para validar

Comments
1 min read
Spring Boot + MySQL + Spring Data JPA: A Beginner's Guide to REST API CRUD Operations

Spring Boot + MySQL + Spring Data JPA: A Beginner's Guide to REST API CRUD Operations

13
Comments
4 min read
SQL Common Table Expressions and Window functions

SQL Common Table Expressions and Window functions

7
Comments 1
7 min read
Setup a Local Database

Setup a Local Database

2
Comments
2 min read
What are the most essential variables in SQL?

What are the most essential variables in SQL?

3
Comments
2 min read
SQL::Inserter for faster/multi-row inserting

SQL::Inserter for faster/multi-row inserting

1
Comments
4 min read
Creating a Countries API in Django with MySQL Database

Creating a Countries API in Django with MySQL Database

3
Comments 2
3 min read
Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Comments
3 min read
How to Build MySQL Admin Tools in 6 Steps [VIDEO]

How to Build MySQL Admin Tools in 6 Steps [VIDEO]

Comments
8 min read
How to use the MySQL Terraform Provider

How to use the MySQL Terraform Provider

1
Comments
5 min read
Using MySQL Variables

Using MySQL Variables

2
Comments
6 min read
MySql: Compact sensor data to minute averages

MySql: Compact sensor data to minute averages

Comments
1 min read
Migrate a MySQL database to a new version and cloud provider

Migrate a MySQL database to a new version and cloud provider

Comments
9 min read
PHP for Beginners

PHP for Beginners

3
Comments
3 min read
ClickHouse Advanced Tutorial: Apply CDC from MySQL to ClickHouse

ClickHouse Advanced Tutorial: Apply CDC from MySQL to ClickHouse

2
Comments 1
7 min read
Multi-Role System in Laravel

Multi-Role System in Laravel

1
Comments
2 min read
Migrating Sequences from Dynamo to MySQL

Migrating Sequences from Dynamo to MySQL

2
Comments
3 min read
Deploy Node-Express-MySQL app on Railway for free (no credit card required)

Deploy Node-Express-MySQL app on Railway for free (no credit card required)

1
Comments 2
8 min read
[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

6
Comments
5 min read
How to Reset MySQL or MariaDB Root Password on Ubuntu 20.04

How to Reset MySQL or MariaDB Root Password on Ubuntu 20.04

Comments
2 min read
How to use Emojis in a Python + Django + MySQL project

How to use Emojis in a Python + Django + MySQL project

Comments
1 min read
How To Add A New Column In An Existing Table Using MySQL

How To Add A New Column In An Existing Table Using MySQL

2
Comments
2 min read
How to Create a Pseudo MySQL Foreign Data Wrapper for Supabase with PostgreSQL and Edge Functions

How to Create a Pseudo MySQL Foreign Data Wrapper for Supabase with PostgreSQL and Edge Functions

1
Comments
8 min read
Connect Python with MySQL database ( mysql-connector )

Connect Python with MySQL database ( mysql-connector )

Comments
1 min read
REST API with Go, Chi, MySQL and sqlx

REST API with Go, Chi, MySQL and sqlx

12
Comments 2
7 min read
Don't underestimate SQL

Don't underestimate SQL

10
Comments 4
2 min read
Order by random Optimization

Order by random Optimization

Comments
5 min read
A Guide to Subqueries in MySQL

A Guide to Subqueries in MySQL

Comments
5 min read
mysql: three things you (probably) didn't know you could do with the mysql command

mysql: three things you (probably) didn't know you could do with the mysql command

1
Comments
4 min read
Stop Using whereDate() Laravel

Stop Using whereDate() Laravel

1
Comments
1 min read
Character Sets vs. Collations in a MySQL Database Infrastructure

Character Sets vs. Collations in a MySQL Database Infrastructure

Comments
7 min read
Speeding up MySQL for testing or development

Speeding up MySQL for testing or development

Comments
3 min read
mysql support! — pebl supports mysql with release 0.0.6

mysql support! — pebl supports mysql with release 0.0.6

Comments
2 min read
Docker for Beginners: Crafting Your Backend Development Environment

Docker for Beginners: Crafting Your Backend Development Environment

58
Comments 3
6 min read
Connecting to MySQL database with Sequelize in Node.js

Connecting to MySQL database with Sequelize in Node.js

Comments
4 min read
ClickHouse Advanced Tutorial: Performance Comparison with MySQL

ClickHouse Advanced Tutorial: Performance Comparison with MySQL

2
Comments 1
6 min read
Create a Spring Boot application with a MySQL backend

Create a Spring Boot application with a MySQL backend

1
Comments
7 min read
What is MySQL GUI and How to Create One

What is MySQL GUI and How to Create One

Comments
7 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

2
Comments 1
3 min read
Create a trigger in MySQL in SQLAlchemy migration

Create a trigger in MySQL in SQLAlchemy migration

Comments
1 min read
Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

Comments
2 min read
A Guide to ACID In MySQL

A Guide to ACID In MySQL

Comments
6 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

12
Comments 1
4 min read
loading...