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

10
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

5
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

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

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

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

5
Comments
1 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
MariaDB vs. MySQL For WordPress

MariaDB vs. MySQL For WordPress

8
Comments
2 min read
Import and Export Large SQL File in Laragon

Import and Export Large SQL File in Laragon

13
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.

4
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
Handling concurrency with Intention exclusive lock on row

Handling concurrency with Intention exclusive lock on row

1
Comments
3 min read
MySQL Learning websites

MySQL Learning websites

2
Comments 1
1 min read
How to Install MySQL 8 on macOS Using Homebrew

How to Install MySQL 8 on macOS Using Homebrew

4
Comments
6 min read
Docker on Windows 10: mysql:8.0.30-debian log files

Docker on Windows 10: mysql:8.0.30-debian log files

6
Comments
4 min read
Python: executing MySQL stored procedures which return multiple result sets.

Python: executing MySQL stored procedures which return multiple result sets.

3
Comments
4 min read
MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

2
Comments
8 min read
Install XAMPP on your linux system

Install XAMPP on your linux system

1
Comments
1 min read
Docker, NodeJS, and MySQL 8

Docker, NodeJS, and MySQL 8

2
Comments
1 min read
Aurora, Where Is My Data? Extreme IOPS Optimization for MySQL

Aurora, Where Is My Data? Extreme IOPS Optimization for MySQL

7
Comments
4 min read
PostgreSQL unit-11

PostgreSQL unit-11

Comments
1 min read
After 6 years of practicing MongoDB, Here are my thoughts on MongoDB vs MySQL

After 6 years of practicing MongoDB, Here are my thoughts on MongoDB vs MySQL

6
Comments
4 min read
How to start a MySQL Instance with Podman

How to start a MySQL Instance with Podman

6
Comments 1
3 min read
When you should use columnar databases and not Postgres, MySQL, or MongoDB

When you should use columnar databases and not Postgres, MySQL, or MongoDB

3
Comments 2
8 min read
Transitioning from NoSQL to also implementing SQL

Transitioning from NoSQL to also implementing SQL

3
Comments
1 min read
How to Setup Keycloak With MySQL Database using CLI in Docker

How to Setup Keycloak With MySQL Database using CLI in Docker

2
Comments
3 min read
Here is the Java Backend to my IMDb Clone!

Here is the Java Backend to my IMDb Clone!

9
Comments
5 min read
How to Connect WSL2 (with Laravel App) to a XAMPP MySql Server on Windows

How to Connect WSL2 (with Laravel App) to a XAMPP MySql Server on Windows

3
Comments
3 min read
PostgreSQL unit-9

PostgreSQL unit-9

Comments
1 min read
Flutter Youtube List With PHP & MySql

Flutter Youtube List With PHP & MySql

2
Comments
2 min read
PostgreSQL unit-7

PostgreSQL unit-7

Comments
1 min read
PostgreSQL unit-8

PostgreSQL unit-8

Comments
1 min read
PostgresSQL unit-6

PostgresSQL unit-6

Comments
1 min read
Create a Grant Application

Create a Grant Application

3
Comments 2
4 min read
Create a database and associate it to a user - MySQL

Create a database and associate it to a user - MySQL

1
Comments
1 min read
8 Week SQL Challenge: Case Study #2 Pizza Runner

8 Week SQL Challenge: Case Study #2 Pizza Runner

Comments 2
10 min read
Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

1
Comments
12 min read
loading...