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.
Schemas em SQL: Indexes e B+ trees

Schemas em SQL: Indexes e B+ trees

6
Comments 2
4 min read
Multiple-Column Indexes and Hashing: The Ultimate Guide to Boosting Database Performance

Multiple-Column Indexes and Hashing: The Ultimate Guide to Boosting Database Performance

5
Comments 1
4 min read
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

6
Comments
4 min read
The Ultimate Guide to MySQL COLLATE: Decoding Modifiers, Combinations, and Real-world Applications

The Ultimate Guide to MySQL COLLATE: Decoding Modifiers, Combinations, and Real-world Applications

5
Comments
4 min read
A Deep Dive into MySQL Enums: The Good, The Bad, and The Ugly Operations

A Deep Dive into MySQL Enums: The Good, The Bad, and The Ugly Operations

11
Comments
4 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
Benchmarking Trilogy : Is it really the future of Rails ?

Benchmarking Trilogy : Is it really the future of Rails ?

15
Comments 2
5 min read
How to tabulate a JSON document in MySQL

How to tabulate a JSON document in MySQL

1
Comments
2 min read
Fix MySQL Error: Access Denied for User ‘root’@’localhost’

Fix MySQL Error: Access Denied for User ‘root’@’localhost’

26
Comments
3 min read
.Net with MySql

.Net with MySql

2
Comments 2
5 min read
Amazon RDS for MySQL

Amazon RDS for MySQL

Comments
1 min read
MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

8
Comments
4 min read
The Enigma of MySQL's INT(11): Unraveling the Mystery

The Enigma of MySQL's INT(11): Unraveling the Mystery

8
Comments
3 min read
Rust & MySQL: JSON serialisation of result sets retrieved using crate sqlx.

Rust & MySQL: JSON serialisation of result sets retrieved using crate sqlx.

5
Comments
6 min read
Villámgyors MySQL ORDER BY RAND() lekérdezés

Villámgyors MySQL ORDER BY RAND() lekérdezés

Comments
3 min read
Fix Missing MySQL Extension Error in WordPress

Fix Missing MySQL Extension Error in WordPress

1
Comments
2 min read
MySQL Database Migration to a Remote Server from a .gz mysqldump file

MySQL Database Migration to a Remote Server from a .gz mysqldump file

Comments
10 min read
How to simplify database operations using MySQL stored procedures

How to simplify database operations using MySQL stored procedures

Comments
7 min read
How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

1
Comments
2 min read
Integration Test MySQL Store with testcontainers-go

Integration Test MySQL Store with testcontainers-go

3
Comments
4 min read
Explanation of MySQL table field types

Explanation of MySQL table field types

Comments
4 min read
Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

1
Comments
4 min read
UTF-8 in MySQL

UTF-8 in MySQL

4
Comments 2
6 min read
Understanding Joins in SQL

Understanding Joins in SQL

4
Comments 2
3 min read
An Introduction to MySQL Database

An Introduction to MySQL Database

Comments
2 min read
loading...