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.
Comparaison entre mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup

Comparaison entre mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup

6
Comments 1
5 min read
Introdução a Modelagem de Banco de Dados - SQL

Introdução a Modelagem de Banco de Dados - SQL

7
Comments
5 min read
There are many options for connecting MySQL from Python, but let's use PyMySQL or mysql-connector-python for now.

There are many options for connecting MySQL from Python, but let's use PyMySQL or mysql-connector-python for now.

13
Comments 1
3 min read
How to add data from CSV file to MySQL using Python

How to add data from CSV file to MySQL using Python

5
Comments
2 min read
Deadlock in mysql

Deadlock in mysql

3
Comments
2 min read
Introdução aos JOINs - SQL

Introdução aos JOINs - SQL

6
Comments
3 min read
Funções mais Usadas no SQL

Funções mais Usadas no SQL

5
Comments
5 min read
Understand SQL cartisien product !

Understand SQL cartisien product !

3
Comments
1 min read
Adding MySQL 8 to Laragon

Adding MySQL 8 to Laragon

17
Comments 1
2 min read
How To Install WordPress with LAMP on Ubuntu 20.04

How To Install WordPress with LAMP on Ubuntu 20.04

7
Comments
4 min read
Como criar containers com PHP, MySQL e NGINX utilizando o Docker Compose

Como criar containers com PHP, MySQL e NGINX utilizando o Docker Compose

14
Comments 6
10 min read
Import large MySQL DB into AWS RDS

Import large MySQL DB into AWS RDS

11
Comments
2 min read
What is the difference between DATETIME and TIMESTAMP data type in MySQL?

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

20
Comments 2
3 min read
Configurando ambiente PHP no Linux

Configurando ambiente PHP no Linux

7
Comments
4 min read
Introdução a Manipulação de Dados - SQL

Introdução a Manipulação de Dados - SQL

6
Comments
4 min read
Introdução a Filtragem de Dados - SQL

Introdução a Filtragem de Dados - SQL

5
Comments
4 min read
Restoring MySQL Database from .frm and .ibd Files on MacOS

Restoring MySQL Database from .frm and .ibd Files on MacOS

10
Comments
5 min read
Introduction to MySQL

Introduction to MySQL

5
Comments
4 min read
Introdução a Pesquisa de Dados - SQL

Introdução a Pesquisa de Dados - SQL

7
Comments
5 min read
Introdução ao SQL

Introdução ao SQL

10
Comments 6
4 min read
Flask Blog Tutorial #2: User Registration and Interacting with MySQL

Flask Blog Tutorial #2: User Registration and Interacting with MySQL

6
Comments
6 min read
🐳<docker, mysql, rails> error: 'Plugin caching_sha2_password could not be loaded' when run 'db:create'

🐳<docker, mysql, rails> error: 'Plugin caching_sha2_password could not be loaded' when run 'db:create'

2
Comments
1 min read
Optimizing your MySQL queries

Optimizing your MySQL queries

187
Comments 2
8 min read
MySQL Materialized Views

MySQL Materialized Views

8
Comments
3 min read
5 cool Perl/Raku or Programming links

5 cool Perl/Raku or Programming links

5
Comments 1
1 min read
Overview Of SQL Stored Procedures

Overview Of SQL Stored Procedures

7
Comments
3 min read
Overview Of SQL Stored Procedures

Overview Of SQL Stored Procedures

6
Comments
3 min read
[mysql curtas] Função case no MySQL

[mysql curtas] Função case no MySQL

7
Comments
1 min read
Order of Execution in a SQL Query.

Order of Execution in a SQL Query.

7
Comments
5 min read
Play with Docker: install MySQL and realize data persistence

Play with Docker: install MySQL and realize data persistence

6
Comments
3 min read
How to complete a PUT request in Sequelize

How to complete a PUT request in Sequelize

6
Comments 1
1 min read
(Premium)OAuth 2.0 (Google) using NodeJS, MySQL, JWT + ReactJS

(Premium)OAuth 2.0 (Google) using NodeJS, MySQL, JWT + ReactJS

11
Comments 1
1 min read
Handling concurrent mysql transaction request with sequelize

Handling concurrent mysql transaction request with sequelize

12
Comments 1
1 min read
Connect MySQL to Apache NetBeans 🚀

Connect MySQL to Apache NetBeans 🚀

6
Comments
1 min read
How To Reset MySQL Root Password?

How To Reset MySQL Root Password?

6
Comments
1 min read
#SQL na unha: recursos do SGBD

#SQL na unha: recursos do SGBD

6
Comments
3 min read
#SQL na unha: manipulando dados

#SQL na unha: manipulando dados

7
Comments
6 min read
Como liberar acesso remoto do MySql server no Ubuntu

Como liberar acesso remoto do MySql server no Ubuntu

2
Comments
1 min read
Why sanitizing input is crucial, and can save your business

Why sanitizing input is crucial, and can save your business

2
Comments 1
1 min read
Which would you go for? Spring boot cron job,scheduled tasks vs Events in Mysql.

Which would you go for? Spring boot cron job,scheduled tasks vs Events in Mysql.

2
Comments
1 min read
Install MYSQL on Ubuntu server 18.04

Install MYSQL on Ubuntu server 18.04

9
Comments 5
4 min read
How to save JSON array in MySQL with TypeORM

How to save JSON array in MySQL with TypeORM

11
Comments
4 min read
#SQL na unha: definindo estrutura do banco

#SQL na unha: definindo estrutura do banco

2
Comments
4 min read
Como criar um container com MySQL Server com Docker e conectá-lo no Workbench [Linux]

Como criar um container com MySQL Server com Docker e conectá-lo no Workbench [Linux]

20
Comments 2
2 min read
#SQL na unha: banco de dados e primeiros comandos

#SQL na unha: banco de dados e primeiros comandos

4
Comments 2
4 min read
Mysql Dockerfile --> Docker container. 🐧🐳

Mysql Dockerfile --> Docker container. 🐧🐳

2
Comments
2 min read
init/seed a MySQL database from a docker-compose file

init/seed a MySQL database from a docker-compose file

5
Comments 1
3 min read
How to create database MySQL with Docker

How to create database MySQL with Docker

12
Comments
2 min read
MySQL MariaDB setup on Linux Ubuntu with SSL/TLS - 2022 - Video

MySQL MariaDB setup on Linux Ubuntu with SSL/TLS - 2022 - Video

7
Comments 1
1 min read
React CRUD operations using PHP API and MySQL

React CRUD operations using PHP API and MySQL

27
Comments 2
8 min read
Easiest way to setup MySQL/MariaDB with TLS/SSL in 10 minutes- v10.5 - Any OS - Ubuntu Focal | Developer Tharun

Easiest way to setup MySQL/MariaDB with TLS/SSL in 10 minutes- v10.5 - Any OS - Ubuntu Focal | Developer Tharun

14
Comments 2
8 min read
Redis helps avoiding racing conditions

Redis helps avoiding racing conditions

8
Comments
5 min read
How to Reset MySQL root password in Ubuntu

How to Reset MySQL root password in Ubuntu

9
Comments
3 min read
MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8

MySQL/MariaDB character sets and collations explained – why utf8 is not UTF-8

11
Comments 2
6 min read
How to avoid the race condition and the negative value

How to avoid the race condition and the negative value

6
Comments
4 min read
TIL: MySQL timestamp column can't go beyond '2038-01-19 03:14:07'

TIL: MySQL timestamp column can't go beyond '2038-01-19 03:14:07'

2
Comments 3
1 min read
What are the top 9 SQL Queries for freshers?

What are the top 9 SQL Queries for freshers?

5
Comments 1
2 min read
"zsh: command not found: mysql" Macbook M1

"zsh: command not found: mysql" Macbook M1

6
Comments
1 min read
Importing Large SQL File

Importing Large SQL File

4
Comments
2 min read
Building a REST API with Node.js, MySQL, and Express

Building a REST API with Node.js, MySQL, and Express

6
Comments
10 min read
loading...