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.
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
Backups for MySQL with mysqldump

Backups for MySQL with mysqldump

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

A small user messenger system using PHP & MySQL

14
Comments
8 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
Create a MySQL RDS Database Instance with Terraform and connect with MySQL Workbench

Create a MySQL RDS Database Instance with Terraform and connect with MySQL Workbench

22
Comments 2
4 min read
SQL Basics: An Introduction to Structured Query Language

SQL Basics: An Introduction to Structured Query Language

Comments
8 min read
Yet Another Newsletter LOL: Signals!

Yet Another Newsletter LOL: Signals!

12
Comments 3
2 min read
Embed hard-coded SQL into binaries for a cleaner look!

Embed hard-coded SQL into binaries for a cleaner look!

Comments
3 min read
Outer Join Optimization

Outer Join Optimization

4
Comments
5 min read
SQL: Soft Deleting and Unique Constraint

SQL: Soft Deleting and Unique Constraint

1
Comments
4 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

15
Comments
4 min read
5 Strategies for Random Records from DB

5 Strategies for Random Records from DB

5
Comments
5 min read
Install Apache2 and MySQL on Ubuntu Server in Azure

Install Apache2 and MySQL on Ubuntu Server in Azure

1
Comments
5 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

15
Comments
4 min read
Building an Application That Interacts with the Google Maps API

Building an Application That Interacts with the Google Maps API

1
Comments
8 min read
AWS Part 13 -- Aurora で MySQL サーバーを作ってローカル CLI からアクセスする

AWS Part 13 -- Aurora で MySQL サーバーを作ってローカル CLI からアクセスする

Comments
1 min read
The Data You‘ve Left Behind – an Attacker‘s Perspective

The Data You‘ve Left Behind – an Attacker‘s Perspective

1
Comments
7 min read
The Difference Between UTF8 and UTF8MB4 in MySQL

The Difference Between UTF8 and UTF8MB4 in MySQL

4
Comments
1 min read
Developing Web Applications Using Php and Mysql

Developing Web Applications Using Php and Mysql

2
Comments
6 min read
MongoDB vs MySQL

MongoDB vs MySQL

8
Comments 8
1 min read
Fixing Messy Queries with DbVisualizer – a Guide for MySQL

Fixing Messy Queries with DbVisualizer – a Guide for MySQL

Comments
8 min read
How to create a dockerized full-stack environment with MySQL, NestJS and NextJS

How to create a dockerized full-stack environment with MySQL, NestJS and NextJS

30
Comments 5
10 min read
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
MySQL/Windows/Docker - How to import a dump file to MySQL container

MySQL/Windows/Docker - How to import a dump file to MySQL container

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

How to fix MySQL Syntax Error: Unexpected Identifier

19
Comments 2
1 min read
Using Geospatial Queries in MySQL

Using Geospatial Queries in MySQL

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

Optimizing Queries for Performance: MySQL Edition

5
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

7
Comments 3
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)

3
Comments
1 min read
Mastering Database Indexing: A Comprehensive Guide

Mastering Database Indexing: A Comprehensive Guide

11
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

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

CTF Walkthrough: pentesting.cloud "Aurora Borealis"

3
Comments
2 min read
loading...