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.
How To Generate Test Data for Your Database Project With Python

How To Generate Test Data for Your Database Project With Python

10
Comments 1
8 min read
InnoDB and ibdata1: Things You Need to Know

InnoDB and ibdata1: Things You Need to Know

Comments
5 min read
PHP 8.1: MySQLi: fetch_column function

PHP 8.1: MySQLi: fetch_column function

Comments
1 min read
Connecting to an existing Amazon RDS MySQL Database via RDS Proxy - 2

Connecting to an existing Amazon RDS MySQL Database via RDS Proxy - 2

3
Comments
4 min read
Docker/DB - Isn't it better to set share directory between host and db container?

Docker/DB - Isn't it better to set share directory between host and db container?

Comments
3 min read
Architecting for Security: MySQL Edition

Architecting for Security: MySQL Edition

3
Comments
10 min read
How to fix MySQL Syntax Error: Unexpected Identifier

How to fix MySQL Syntax Error: Unexpected Identifier

3
Comments 2
1 min read
Using Geospatial Queries in MySQL

Using Geospatial Queries in MySQL

1
Comments 1
2 min read
Optimizing Queries for Performance: MySQL Edition

Optimizing Queries for Performance: MySQL Edition

4
Comments 1
9 min read
Fire Up your mysql in a Docker Container 🔥🔥

Fire Up your mysql in a Docker Container 🔥🔥

1
Comments
1 min read
Atomic locks in laravel explained in depth

Atomic locks in laravel explained in depth

6
Comments 2
2 min read
How to solve ERROR 1045 (28000): Access denied for user 'root'@'localhost' (MAC)

How to solve ERROR 1045 (28000): Access denied for user 'root'@'localhost' (MAC)

Comments
1 min read
Mastering Database Indexing: A Comprehensive Guide

Mastering Database Indexing: A Comprehensive Guide

10
Comments 3
3 min read
MySQL in a Nutshell: A Handy Cheatsheet of Frequently Used Queries

MySQL in a Nutshell: A Handy Cheatsheet of Frequently Used Queries

1
Comments
3 min read
SQL Count using Where Clause or Case Statement

SQL Count using Where Clause or Case Statement

2
Comments
3 min read
MySQL: Searching multiple columns at once without LIKE

MySQL: Searching multiple columns at once without LIKE

7
Comments
2 min read
CTF Walkthrough: pentesting.cloud "Aurora Borealis"

CTF Walkthrough: pentesting.cloud "Aurora Borealis"

3
Comments
2 min read
MySQL + Docker + AWS EC2 Simple Tutorial with Amazon Linux (2023)

MySQL + Docker + AWS EC2 Simple Tutorial with Amazon Linux (2023)

2
Comments
2 min read
Innodb_buffer_pool_size

Innodb_buffer_pool_size

1
Comments
4 min read
The Sequelize library simplifies developer life.

The Sequelize library simplifies developer life.

1
Comments
2 min read
MySQL: How to create One-to-Many Relationship

MySQL: How to create One-to-Many Relationship

4
Comments
6 min read
PostgreSQL vs MySQL: Which Best Suits Your Business?

PostgreSQL vs MySQL: Which Best Suits Your Business?

1
Comments
3 min read
Building a User Authentication API using Python Flask and MySQL

Building a User Authentication API using Python Flask and MySQL

9
Comments 1
11 min read
How to Upgrade MySQL 5.7 to 8.0 on Mac

How to Upgrade MySQL 5.7 to 8.0 on Mac

5
Comments
2 min read
Build a custom MySQL Docker Container

Build a custom MySQL Docker Container

37
Comments 3
6 min read
Querying for Data in MySQL is Slow

Querying for Data in MySQL is Slow

Comments
1 min read
SQL Commands Cheat Sheet

SQL Commands Cheat Sheet

3
Comments
11 min read
REST API with ASP.NET and MySQL

REST API with ASP.NET and MySQL

3
Comments
6 min read
New in PHP 8.2: mysqli_execute_query / mysqli::execute_query

New in PHP 8.2: mysqli_execute_query / mysqli::execute_query

5
Comments 1
1 min read
Connect Your Node.js Project to MySQL Database Locally

Connect Your Node.js Project to MySQL Database Locally

Comments
2 min read
mysql: getting a grip on dates, times, and timezones

mysql: getting a grip on dates, times, and timezones

4
Comments 3
14 min read
What is key_buffer_size in MySQL?

What is key_buffer_size in MySQL?

2
Comments 1
1 min read
Connecting Deepnote to TiDB Cloud Serverless Cluster

Connecting Deepnote to TiDB Cloud Serverless Cluster

1
Comments 2
2 min read
Bulk Loading Data In PostgreSQL With Node.js and Sequelize

Bulk Loading Data In PostgreSQL With Node.js and Sequelize

Comments
5 min read
How SQL engine implement the isolation levels in MySQL

How SQL engine implement the isolation levels in MySQL

9
Comments
3 min read
Reset MySQL Root Password (Version 8 and above)

Reset MySQL Root Password (Version 8 and above)

Comments
2 min read
Aorm, A GoLang library for operate database

Aorm, A GoLang library for operate database

6
Comments
10 min read
How to connect Zoho CRM with Mysql using Python

How to connect Zoho CRM with Mysql using Python

1
Comments
2 min read
Installing MySQL Server and MySQL Workbench

Installing MySQL Server and MySQL Workbench

5
Comments
1 min read
Upgrading MySQL 5.7 to MariaDB 10 on Ubuntu 18

Upgrading MySQL 5.7 to MariaDB 10 on Ubuntu 18

1
Comments 1
1 min read
【XAMPP】How to fix "Error: MySQL shutdown unexpectedly. "

【XAMPP】How to fix "Error: MySQL shutdown unexpectedly. "

4
Comments
1 min read
MariaDB vs. MySQL For WordPress

MariaDB vs. MySQL For WordPress

7
Comments
2 min read
Blue/Green Deployments for RDS: How Fast is a Switchover? 

Blue/Green Deployments for RDS: How Fast is a Switchover? 

13
Comments 3
3 min read
3 Steps To Quickly Build A MySQL Online Database

3 Steps To Quickly Build A MySQL Online Database

6
Comments
5 min read
How sql engine handle join internally - part 2

How sql engine handle join internally - part 2

15
Comments 4
3 min read
Secure your connection string with AWS KMS

Secure your connection string with AWS KMS

3
Comments
11 min read
MySQL 8: short syntax for select all

MySQL 8: short syntax for select all

6
Comments 1
1 min read
【MySQL】How to fix garbled text in command prompt (1)

【MySQL】How to fix garbled text in command prompt (1)

5
Comments
2 min read
Rust: Using DateTime in Diesel with MySQL

Rust: Using DateTime in Diesel with MySQL

1
Comments
1 min read
PHP 8.1: MySQLi: Bind in Execute

PHP 8.1: MySQLi: Bind in Execute

6
Comments
1 min read
Laravel project

Laravel project

5
Comments
1 min read
Make Deno MySQL driver works better

Make Deno MySQL driver works better

8
Comments
4 min read
Docker Compose: how to wait for the MySQL server container to be ready?

Docker Compose: how to wait for the MySQL server container to be ready?

7
Comments
14 min read
Install XAMPP on your linux system

Install XAMPP on your linux system

1
Comments
1 min read
Import and Export Large SQL File in Laragon

Import and Export Large SQL File in Laragon

9
Comments 1
2 min read
If There Only Was a Simple Way To Test Software Without Installing It... Oh, There Is?

If There Only Was a Simple Way To Test Software Without Installing It... Oh, There Is?

5
Comments
4 min read
pgloader Docker: migrating from Docker & localhost MySQL to localhost PostgreSQL.

pgloader Docker: migrating from Docker & localhost MySQL to localhost PostgreSQL.

3
Comments
6 min read
How to create Stored Procedure in MySQL

How to create Stored Procedure in MySQL

2
Comments
1 min read
How to create function in MySQL

How to create function in MySQL

3
Comments
1 min read
How to use delimiter in MySQL

How to use delimiter in MySQL

2
Comments
1 min read
loading...