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.
Guide to MySQL Constraints

Guide to MySQL Constraints

2
Comments
3 min read
Simplify Your PHP Database Connections with This Static Class

Simplify Your PHP Database Connections with This Static Class

Comments
6 min read
What is a Database? An Introduction

What is a Database? An Introduction

1
Comments
1 min read
Accessing MySQL Server from a Remote Machine in the Same Network

Accessing MySQL Server from a Remote Machine in the Same Network

15
Comments 1
2 min read
Complete Guide to MariaDB Logs: Audit, Configuration, and More

Complete Guide to MariaDB Logs: Audit, Configuration, and More

Comments
7 min read
Finding Skipped Reference Numbers in DB

Finding Skipped Reference Numbers in DB

Comments
2 min read
Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs

Common pitfalls and solutions for mysqldump/xtrabackup-based SSTs

Comments
2 min read
Introducing EasyREST

Introducing EasyREST

4
Comments
5 min read
MySQL Performance Tuning Techniques

MySQL Performance Tuning Techniques

3
Comments
7 min read
MySQL Master-Slave Replication Delay Optimization

MySQL Master-Slave Replication Delay Optimization

Comments
7 min read
MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

1
Comments
1 min read
How to move data from a private network to another?

How to move data from a private network to another?

Comments
5 min read
How to install MySql on Linux

How to install MySql on Linux

Comments
1 min read
You are My-SQL 🧡

You are My-SQL 🧡

Comments
4 min read
How to generate realistic test data in MySQL for QA environments

How to generate realistic test data in MySQL for QA environments

1
Comments
3 min read
MySQL WorkBench: Create, alter & Drop

MySQL WorkBench: Create, alter & Drop

1
Comments
3 min read
How Implicit Conversions Can Kill Database Performance

How Implicit Conversions Can Kill Database Performance

1
Comments
6 min read
CRUD Java, MySQL e JDBC

CRUD Java, MySQL e JDBC

Comments
3 min read
Fixing MySQL Shutdown Unexpectedly Error

Fixing MySQL Shutdown Unexpectedly Error

1
Comments
2 min read
A Beginner’s Guide to MySQL Character Sets and Collations

A Beginner’s Guide to MySQL Character Sets and Collations

Comments
2 min read
Create New User in MySQL & Grant Access

Create New User in MySQL & Grant Access

10
Comments 3
2 min read
Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

7
Comments 1
2 min read
Reduzindo o Uso de MemĂłria do MySQL no Docker

Reduzindo o Uso de MemĂłria do MySQL no Docker

Comments
2 min read
Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Comments
3 min read
Running MySQl in Linux (with/ without podman container with phpmyadmin)

Running MySQl in Linux (with/ without podman container with phpmyadmin)

Comments
4 min read
loading...