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.
React Node MySql

React Node MySql

6
Comments
2 min read
MySQL- RDBMS

MySQL- RDBMS

5
Comments
3 min read
Hyper QuickStart to MySQL

Hyper QuickStart to MySQL

2
Comments
2 min read
Prisma ORM update explicit many to many relations

Prisma ORM update explicit many to many relations

18
Comments 5
1 min read
Create a Distributed Database Solution Based on PostgreSQL & openGauss

Create a Distributed Database Solution Based on PostgreSQL & openGauss

5
Comments
6 min read
MySQL Cheat sheet

MySQL Cheat sheet

20
Comments
7 min read
Quickops 3: too many connections to my database and what can i do

Quickops 3: too many connections to my database and what can i do

5
Comments 2
2 min read
Strapi v4 setup with Docker Compose and MySQL

Strapi v4 setup with Docker Compose and MySQL

8
Comments
2 min read
[Django] Connect Django Application to a MySQL Server

[Django] Connect Django Application to a MySQL Server

3
Comments
2 min read
Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded" errors

Fixing "Authentication plugin 'caching_sha2_password' cannot be loaded" errors

2
Comments
2 min read
Using cursors and for loops in MySQL

Using cursors and for loops in MySQL

2
Comments
4 min read
Setup Passport functionality in Laravel

Setup Passport functionality in Laravel

4
Comments
1 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

4
Comments
5 min read
Developing a simple URL shortener with node, express, ejs and mysql

Developing a simple URL shortener with node, express, ejs and mysql

6
Comments 6
6 min read
How To Swap 2 Unique Primary Keys In The Same Table With MySQL

How To Swap 2 Unique Primary Keys In The Same Table With MySQL

6
Comments
1 min read
[Easy] Complete user Login and Registration using NodeJS, ExpressJs, MySQL and JWT.

[Easy] Complete user Login and Registration using NodeJS, ExpressJs, MySQL and JWT.

9
Comments 7
5 min read
Creating a table from an existing MySQL table using SQL Query

Creating a table from an existing MySQL table using SQL Query

3
Comments
4 min read
How To Delete First Or Last n Rows In MySQL

How To Delete First Or Last n Rows In MySQL

8
Comments
1 min read
Replication between On-Premise MySQL and MySQL on AWS RDS

Replication between On-Premise MySQL and MySQL on AWS RDS

4
Comments
3 min read
7 modern and practical MySQL/MariaDB features you should know and use

7 modern and practical MySQL/MariaDB features you should know and use

3
Comments
5 min read
How to join MySQL and Postgres in a live materialized view

How to join MySQL and Postgres in a live materialized view

15
Comments
6 min read
Memory Error - Out of sort memory, consider increasing sort buffer size

Memory Error - Out of sort memory, consider increasing sort buffer size

4
Comments
1 min read
How to fix mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@'localhost' error?

How to fix mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@'localhost' error?

5
Comments
2 min read
How to fix phpMyAdmin “Login without a password is forbidden by configuration” error?

How to fix phpMyAdmin “Login without a password is forbidden by configuration” error?

2
Comments
1 min read
Collation Relation, what's your Translation?

Collation Relation, what's your Translation?

5
Comments
6 min read
MySQL/MyBatis | Using Dynamic Query

MySQL/MyBatis | Using Dynamic Query

4
Comments
2 min read
Deploy a MySQL database server in Kubernetes - Static

Deploy a MySQL database server in Kubernetes - Static

16
Comments 3
5 min read
Elementary OS - Dev Environment Setup

Elementary OS - Dev Environment Setup

47
Comments 3
8 min read
Instant Realtime APIs using PostgreSQL, MySQL, SQLite, SQLServer and Planetscale.

Instant Realtime APIs using PostgreSQL, MySQL, SQLite, SQLServer and Planetscale.

3
Comments
6 min read
Mitigating MySQL Downtime for big migrations

Mitigating MySQL Downtime for big migrations

3
Comments
2 min read
What is the difference between UNION and UNION ALL in SQL?

What is the difference between UNION and UNION ALL in SQL?

16
Comments 2
2 min read
PlanetScale integrates with Arctype's MySQL GUI

PlanetScale integrates with Arctype's MySQL GUI

7
Comments
1 min read
Postgres! What is it?

Postgres! What is it?

5
Comments
4 min read
Create a multi tenant application in Nest.js Part 2 (database setup using Sequelize & mongoose)

Create a multi tenant application in Nest.js Part 2 (database setup using Sequelize & mongoose)

9
Comments
5 min read
A Brief Introduction to MySQL Transactions

A Brief Introduction to MySQL Transactions

3
Comments
4 min read
How to Add a Default Value to an Existing Column in MySQL

How to Add a Default Value to an Existing Column in MySQL

15
Comments
2 min read
How to Make a major change to all your foreign keys (Mysql, Laravel)

How to Make a major change to all your foreign keys (Mysql, Laravel)

3
Comments
2 min read
Temporary Tables in MySQL: A High-level Overview

Temporary Tables in MySQL: A High-level Overview

2
Comments
4 min read
How to Partition MySQL Tables

How to Partition MySQL Tables

4
Comments
4 min read
Top 5 MySQL GUI tools in 2021

Top 5 MySQL GUI tools in 2021

8
Comments
10 min read
Transitioning from MySQL to MongoDB

Transitioning from MySQL to MongoDB

7
Comments
6 min read
SQL Constraints

SQL Constraints

3
Comments
4 min read
設定 MariaDB / MySQL 真・UTF-8 編碼

設定 MariaDB / MySQL 真・UTF-8 編碼

6
Comments
1 min read
Bypassing ModSecurity WAF

Bypassing ModSecurity WAF

4
Comments
2 min read
How To Secure MySQL 8 with SSL/TLS on Ubuntu 20.04

How To Secure MySQL 8 with SSL/TLS on Ubuntu 20.04

4
Comments
6 min read
Calculate Distance between 2 Geo Locations in PHP MySQL

Calculate Distance between 2 Geo Locations in PHP MySQL

33
Comments 3
2 min read
How To Setup A Linux, Apache, MySQL, PHP Dev Environment On Ubuntu

How To Setup A Linux, Apache, MySQL, PHP Dev Environment On Ubuntu

6
Comments 4
6 min read
How to Install MySQL on Ubuntu 18.04

How to Install MySQL on Ubuntu 18.04

5
Comments
4 min read
Set Up MySQL 8 Master-Slave Replication on Ubuntu 20.04

Set Up MySQL 8 Master-Slave Replication on Ubuntu 20.04

3
Comments 1
4 min read
A curated list of useful tips, tricks and links related to Laravel, Vue, MySQL and other web development related content

A curated list of useful tips, tricks and links related to Laravel, Vue, MySQL and other web development related content

5
Comments
1 min read
Security leaks on our website. How we got hacked?

Security leaks on our website. How we got hacked?

5
Comments
7 min read
Learning MySQL with basic SQL Commands

Learning MySQL with basic SQL Commands

8
Comments
6 min read
A Guide to MySQL JOINS

A Guide to MySQL JOINS

3
Comments
5 min read
How to Update the Database After a Drag-and-Drop Operation

How to Update the Database After a Drag-and-Drop Operation

40
Comments 5
7 min read
Guía Practica de Contenedores: Desarrollando una API CRUD con Node.js, Express y MySQL (1/3)

Guía Practica de Contenedores: Desarrollando una API CRUD con Node.js, Express y MySQL (1/3)

6
Comments 1
7 min read
Visual Studio Code: MySQL Extension

Visual Studio Code: MySQL Extension

3
Comments
2 min read
Choose the Best SQL Adapter for Your Python Project

Choose the Best SQL Adapter for Your Python Project

2
Comments
4 min read
MYSQL FOR BEGINNERS! - PART ONE

MYSQL FOR BEGINNERS! - PART ONE

4
Comments
2 min read
From 0 to 5.000.000 monthly views

From 0 to 5.000.000 monthly views

31
Comments 6
6 min read
SQL Lock to give you shock

SQL Lock to give you shock

3
Comments
2 min read
loading...