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

6
Comments
5 min read
Indexing In MySQL

Indexing In MySQL

1
Comments
2 min read
We Created a Low-Code IDE for Rapidly Building MySQL Web Applications

We Created a Low-Code IDE for Rapidly Building MySQL Web Applications

1
Comments
7 min read
Full Text Search in MySQL

Full Text Search in MySQL

Comments
11 min read
Install and configure mysql in ubuntu 20.04

Install and configure mysql in ubuntu 20.04

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

【MySQL】When using "NULL" in WHERE CLAUSE

Comments
1 min read
Using MariaDB and mySQL in web applications

Using MariaDB and mySQL in web applications

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

A small user messenger system using PHP & MySQL

2
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
Rails deployment pipeline with Planetscale & Heroku

Rails deployment pipeline with Planetscale & Heroku

2
Comments
4 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

Comments
2 min read
Outer Join Optimization

Outer Join Optimization

2
Comments
5 min read
Yet Another Newsletter LOL: Signals!

Yet Another Newsletter LOL: Signals!

12
Comments 3
2 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

9
Comments
4 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
Eloquent ORM: First Steps.

Eloquent ORM: First Steps.

3
Comments
5 min read
5 Strategies for Random Records from DB

5 Strategies for Random Records from DB

1
Comments
5 min read
SQL Basics: An Introduction to Structured Query Language

SQL Basics: An Introduction to Structured Query Language

Comments
8 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
SQL: Soft Deleting and Unique Constraint

SQL: Soft Deleting and Unique Constraint

1
Comments
4 min read
Laravel useful DB/Eloquent functions:

Laravel useful DB/Eloquent functions:

2
Comments
1 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

11
Comments
4 min read
Understanding MySQL EXPLAIN output

Understanding MySQL EXPLAIN output

13
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

1
Comments
1 min read
MongoDB vs MySQL

MongoDB vs MySQL

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

Developing Web Applications Using Php and Mysql

2
Comments
6 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

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

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

1
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
How to fix MySQL Syntax Error: Unexpected Identifier

How to fix MySQL Syntax Error: Unexpected Identifier

2
Comments 2
1 min read
Using Geospatial Queries in MySQL

Using Geospatial Queries in MySQL

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

Optimizing Queries for Performance: MySQL Edition

3
Comments 1
9 min read
Atomic locks in laravel explained in depth

Atomic locks in laravel explained in depth

4
Comments 1
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)

Comments
1 min read
Mastering Database Indexing: A Comprehensive Guide

Mastering Database Indexing: A Comprehensive Guide

9
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

6
Comments
2 min read
Install and manage a complete PHP development environment (with https) on a Chromebook (or Debian) with just a few copy-paste

Install and manage a complete PHP development environment (with https) on a Chromebook (or Debian) with just a few copy-paste

4
Comments
5 min read
CTF Walkthrough: pentesting.cloud "Aurora Borealis"

CTF Walkthrough: pentesting.cloud "Aurora Borealis"

3
Comments
2 min read
MySQL + Docker + AWS EC2 Simple Tutorial with Amazon Linux (2023)

MySQL + Docker + AWS EC2 Simple Tutorial with Amazon Linux (2023)

2
Comments
2 min read
The Sequelize library simplifies developer life.

The Sequelize library simplifies developer life.

1
Comments
2 min read
MySQL: How to create One-to-Many Relationship

MySQL: How to create One-to-Many Relationship

1
Comments
6 min read
PostgreSQL vs MySQL: Which Best Suits Your Business?

PostgreSQL vs MySQL: Which Best Suits Your Business?

1
Comments
3 min read
Building a User Authentication API using Python Flask and MySQL

Building a User Authentication API using Python Flask and MySQL

6
Comments 1
11 min read
How to Upgrade MySQL 5.7 to 8.0 on Mac

How to Upgrade MySQL 5.7 to 8.0 on Mac

5
Comments
2 min read
Build a custom MySQL Docker Container

Build a custom MySQL Docker Container

33
Comments 3
6 min read
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
loading...