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.
Data Validation In SQL: 5 Powerful Data Validation Techniques

Data Validation In SQL: 5 Powerful Data Validation Techniques

Comments
11 min read
[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

8
Comments
5 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

65
Comments 1
3 min read
Stepping into Success: Building a PHP Sneakers E-commerce Website from Scratch

Stepping into Success: Building a PHP Sneakers E-commerce Website from Scratch

1
Comments 1
3 min read
Create a trigger in MySQL in SQLAlchemy migration

Create a trigger in MySQL in SQLAlchemy migration

2
Comments
1 min read
How to use Emojis in a Python + Django + MySQL project

How to use Emojis in a Python + Django + MySQL project

1
Comments
1 min read
Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

Comments
2 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

13
Comments 1
4 min read
Migrating from MySQL to PostgreSQL: A Step-by-Step Guide

Migrating from MySQL to PostgreSQL: A Step-by-Step Guide

19
Comments 2
3 min read
store JSON data in a non-relational table in the MySQL database ( Laravel )

store JSON data in a non-relational table in the MySQL database ( Laravel )

Comments
8 min read
REST API with ASP.NET Core and MySql

REST API with ASP.NET Core and MySql

5
Comments
6 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

41
Comments 13
4 min read
Preventing Illicit Uploads in MySQL – secure_file_priv

Preventing Illicit Uploads in MySQL – secure_file_priv

1
Comments
6 min read
hibernate 6 crud operations

hibernate 6 crud operations

11
Comments 1
4 min read
A unique database for every PR using CodeSandbox

A unique database for every PR using CodeSandbox

15
Comments 1
4 min read
Using ULID in Laravel Framework

Using ULID in Laravel Framework

2
Comments
2 min read
How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

35
Comments 1
2 min read
How to add a MySQL Planetscale database as a grafana cloud datasource

How to add a MySQL Planetscale database as a grafana cloud datasource

2
Comments
1 min read
MySQL Basic Select challenges

MySQL Basic Select challenges

Comments
2 min read
run-mariabackup makeover

run-mariabackup makeover

3
Comments
3 min read
MySQL 8.0: Invisible Columns

MySQL 8.0: Invisible Columns

3
Comments
2 min read
CentOS 7 裝 mycli

CentOS 7 裝 mycli

Comments
1 min read
A Guide to ACID In MySQL

A Guide to ACID In MySQL

1
Comments
6 min read
An easy way to use a MySQL database in Node.js (Node.js MySQL vs Node.js MySQL + NanoQL)

An easy way to use a MySQL database in Node.js (Node.js MySQL vs Node.js MySQL + NanoQL)

1
Comments
2 min read
Learning SQL? Here's a grab bag of links.

Learning SQL? Here's a grab bag of links.

3
Comments 3
3 min read
Resolvendo problema de "foreign key constraint" ao migrar o Ghost CMS da v4 para v5

Resolvendo problema de "foreign key constraint" ao migrar o Ghost CMS da v4 para v5

Comments
1 min read
Php artisan migrate throws table base or view on found [Solved]

Php artisan migrate throws table base or view on found [Solved]

1
Comments
1 min read
How to create a Linux VM and Install MySQL Server using Cloudshell

How to create a Linux VM and Install MySQL Server using Cloudshell

6
Comments
4 min read
How to create a Signup page with PHP/MySQL Using ChatGPT: from prompt to result

How to create a Signup page with PHP/MySQL Using ChatGPT: from prompt to result

Comments
5 min read
The old MySQL bug (detective story)

The old MySQL bug (detective story)

1
Comments 1
2 min read
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

5
Comments
1 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 min read
610. Triangle Judgement

610. Triangle Judgement

4
Comments
1 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
Comments
1 min read
【MySQL】When using "NULL" in WHERE CLAUSE

【MySQL】When using "NULL" in WHERE CLAUSE

Comments
1 min read
Cluster table in Your HD

Cluster table in Your HD

3
Comments
3 min read
Best Practices to protect an RDS MySQL Database ✅

Best Practices to protect an RDS MySQL Database ✅

1
Comments
3 min read
The docker-compose Database Snippets for Development

The docker-compose Database Snippets for Development

Comments
1 min read
RDS MySQL Load Testing with Sysbench

RDS MySQL Load Testing with Sysbench

3
Comments
2 min read
All about Structure Query Language (SQL)

All about Structure Query Language (SQL)

Comments
10 min read
Rails deployment pipeline with Planetscale & Heroku

Rails deployment pipeline with Planetscale & Heroku

2
Comments
4 min read
Relational database vs nosql: A Beginner's Guide

Relational database vs nosql: A Beginner's Guide

12
Comments
9 min read
Everything you wanted to know about Auto Increment but were afraid to ask

Everything you wanted to know about Auto Increment but were afraid to ask

2
Comments
6 min read
Problem solving with SQL: Case Study #1 — Danny’s Diner

Problem solving with SQL: Case Study #1 — Danny’s Diner

11
Comments 2
10 min read
Simple query for remove duplicates from table

Simple query for remove duplicates from table

2
Comments
2 min read
how to save react form data into database using Spring boot

how to save react form data into database using Spring boot

10
Comments
5 min read
MySQL joins

MySQL joins

3
Comments 1
3 min read
How to deploy a MySQL server using docker containers

How to deploy a MySQL server using docker containers

1
Comments
2 min read
HAVING Clause In MySQL

HAVING Clause In MySQL

2
Comments
2 min read
Indexing In MySQL

Indexing In MySQL

1
Comments
2 min read
View In MySQL

View In MySQL

2
Comments
1 min read
Install and configure mysql in ubuntu 20.04

Install and configure mysql in ubuntu 20.04

1
Comments
1 min read
How to Create a Docker MySQL Container and Link it with a Spring Boot Application

How to Create a Docker MySQL Container and Link it with a Spring Boot Application

2
Comments
2 min read
2 Ways to Build & Deploy Apps on a MySQL Database

2 Ways to Build & Deploy Apps on a MySQL Database

1
Comments
13 min read
Full Text Search in MySQL

Full Text Search in MySQL

1
Comments
11 min read
A small user messenger system using PHP & MySQL

A small user messenger system using PHP & MySQL

14
Comments
8 min read
Backups for MySQL with mysqldump

Backups for MySQL with mysqldump

1
Comments
5 min read
Setup Spring Boot with JPA and MySQL

Setup Spring Boot with JPA and MySQL

Comments
1 min read
Getting Started With SQL

Getting Started With SQL

5
Comments
4 min read
Eloquent ORM: First Steps.

Eloquent ORM: First Steps.

3
Comments
5 min read
loading...