close
The Wayback Machine - https://web.archive.org/web/20231201212934/https://dev.to/t/mysql

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.
Contributing to a larger open source project!

Contributing to a larger open source project!

Image Image 2
Comments
4 min read
MySQL Operators – A Guide

MySQL Operators – A Guide

Comments
5 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

Comments
5 min read
Streamlining CDC with MySQL, Debezium, Azure Event Hubs, and Functions

Streamlining CDC with MySQL, Debezium, Azure Event Hubs, and Functions

Comments
6 min read
Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Comments
6 min read
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

Image 3
Comments 3
2 min read
NULLs Are Not The Same – A Guide

NULLs Are Not The Same – A Guide

Comments
4 min read
Restore your MySQL Database on PlanetScale

Restore your MySQL Database on PlanetScale

Image Image Image 4
Comments
2 min read
Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Comments
4 min read
Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Comments
4 min read
5 tips to scale MySQL to the tens of millions

5 tips to scale MySQL to the tens of millions

Image Image Image Image 4
Comments
3 min read
Designing a database with MySQL using the Workbench — Part 3

Designing a database with MySQL using the Workbench — Part 3

Comments
6 min read
Automated MySQL Backup Pipeline on AWS S3 using Jenkin

Automated MySQL Backup Pipeline on AWS S3 using Jenkin

Comments
4 min read
How to Use MySQL Database in Total.js with QueryBuilderMySQL?

How to Use MySQL Database in Total.js with QueryBuilderMySQL?

Image Image Image 3
Comments
5 min read
MySQL invisible columns and how to define it with Laravel and Doctrine

MySQL invisible columns and how to define it with Laravel and Doctrine

Image Image Image Image 11
Comments 3
2 min read
Restore or Migrate your MySQL Database to Railway

Restore or Migrate your MySQL Database to Railway

Image Image Image 4
Comments
3 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

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

Image Image Image Image Image 5
Comments
4 min read
How to tabulate a JSON document in MySQL

How to tabulate a JSON document in MySQL

Comments
2 min read
đŸ’Ÿ Automatiser le « backup » d'une base de donnĂ©e MySQL avec NestJS et TypeORM

đŸ’Ÿ Automatiser le « backup » d'une base de donnĂ©e MySQL avec NestJS et TypeORM

Image 1
Comments
12 min read
Image Management and Database Integration with Node.js, Multer, Cloudinary and MySQL

Image Management and Database Integration with Node.js, Multer, Cloudinary and MySQL

Image 1
Comments
5 min read
How to Optimize MySQL Tables: A Comprehensive Guide

How to Optimize MySQL Tables: A Comprehensive Guide

Comments
10 min read
How to build an event management application in Amplication

How to build an event management application in Amplication

Image Image Image Image Image 5
Comments
4 min read
Database GitOps with Bytebase for MySQL

Database GitOps with Bytebase for MySQL

Image Image Image Image Image 9
Comments
3 min read
CRUD Operations in SQL

CRUD Operations in SQL

Image 2
Comments 1
14 min read
Schemas em SQL: Indexes e B+ trees

Schemas em SQL: Indexes e B+ trees

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

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

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

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

Image Image Image Image Image 11
Comments
3 min read
Building a Node.js Authentication System with MySQL: A Step-by-Step Guide

Building a Node.js Authentication System with MySQL: A Step-by-Step Guide

Image Image Image Image Image 14
Comments 4
6 min read
Host is not allowed to connect to this MariaDB server XAMPP

Host is not allowed to connect to this MariaDB server XAMPP

Image 1
Comments
2 min read
MacOS Sonoma: libmysqlclient.21.dylib (no such file, not in dyld cache)

MacOS Sonoma: libmysqlclient.21.dylib (no such file, not in dyld cache)

Comments 4
2 min read
6 useful SQL queries for web developers (MySQL)

6 useful SQL queries for web developers (MySQL)

Image Image Image Image Image 13
Comments
5 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

Image Image Image Image Image 5
Comments 1
4 min read
Rust & MySQL: JSON serialisation of result sets retrieved using crate sqlx.

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

Image Image Image 6
Comments
6 min read
Using MySQL as a NoSQL Document Store - Introduction

Using MySQL as a NoSQL Document Store - Introduction

Comments
7 min read
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

Image Image Image Image Image 10
Comments
4 min read
Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.

Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.

Image Image 2
Comments
20 min read
Benchmarking Trilogy : Is it really the future of Rails ?

Benchmarking Trilogy : Is it really the future of Rails ?

Image Image Image Image Image 11
Comments 2
5 min read
.Net with MySql

.Net with MySql

Image 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

Image Image Image Image 8
Comments
4 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
Auto-Synchronizing an Entire MySQL Database for Data Analysis

Auto-Synchronizing an Entire MySQL Database for Data Analysis

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

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

Integration Test MySQL Store with testcontainers-go

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

Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

Image 1
Comments
4 min read
UTF-8 in MySQL

UTF-8 in MySQL

Image Image 5
Comments 2
6 min read
Understanding Joins in SQL

Understanding Joins in SQL

Image Image Image 4
Comments 2
3 min read
Integration Test MySQL Store (Go)

Integration Test MySQL Store (Go)

Image 1
Comments
11 min read
How to Create a Discussion Forum Using PHP and MySQL?

How to Create a Discussion Forum Using PHP and MySQL?

Image Image Image Image Image 34
Comments 6
9 min read
Access MySQL Document Store from NodeJS Application

Access MySQL Document Store from NodeJS Application

Image Image Image 5
Comments
4 min read
Rust & MySQL: executing MySQL stored procedures which return multiple result sets using crate sqlx.

Rust & MySQL: executing MySQL stored procedures which return multiple result sets using crate sqlx.

Image 1
Comments
10 min read
MariaDB 10.9 on OpenBSD 7.3: Install

MariaDB 10.9 on OpenBSD 7.3: Install

Image Image Image 4
Comments
4 min read
Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

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

Changes in procedures/functions while migrating from MySQL to PostgreSQL

Image 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

Image Image 5
Comments
3 min read
PHP Phone Book

PHP Phone Book

Image Image 7
Comments 2
2 min read
Garanta a EficiĂȘncia: Escolhendo entre tipos String no SQL

Garanta a EficiĂȘncia: Escolhendo entre tipos String no SQL

Image Image Image Image Image 35
Comments 7
4 min read
MySQL Basic Queries: A Beginner’s Guide

MySQL Basic Queries: A Beginner’s Guide

Image Image 2
Comments
4 min read
loading...