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.
SQL Joins Explained - INNER, LEFT, RIGHT, FULL
roxana_haidiner profile

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

#sql #database #mysql #postgres
7
Comments
3 min read
August 2025 At Releem - Recommendations Impact & Redundant Index Detection
drupaladmin profile

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

#mysql #devops #database #webdev
Comments
2 min read
Create MySQL ER Diagrams with a Free Design Tool
roxana_haidiner profile

Create MySQL ER Diagrams with a Free Design Tool

#sql #mysql #database #tooling
6
Comments
4 min read
Automating MySQL Backups with Bash Script & Cron
tanjinsarker profile

Automating MySQL Backups with Bash Script & Cron

#bash #mysql #automation #devops
Comments
4 min read
MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾
xinjie_zou_d67d2805538130 profile

MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

#webdev #frontend #mysql #devops
5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide
princemaxi profile

🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

#linux #aws #mysql #php
1
Comments
10 min read
What is Error Code 1451 in MySQL
sanjay_kumar_f68c88b70eaf profile

What is Error Code 1451 in MySQL

#programming #webdev #mysql
Comments
1 min read
Using CASE to Sort ENUM Values in MySQL
ibrahimalanshor profile

Using CASE to Sort ENUM Values in MySQL

#mysql #sql #database #data
1
Comments
2 min read
Free SQL Tool to Understand Your Database Visually
roxana_haidiner profile

Free SQL Tool to Understand Your Database Visually

#sql #database #tooling #mysql
7
Comments
3 min read
🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)
nuwandev profile

🔐 How to Reset MySQL Root Password (Windows - Beginner Friendly)

#fix #mysql #tutorial #database
1
Comments
1 min read
Mastering RESTful API Integration: Your Guide to Seamless Connections
farlamo profile

Mastering RESTful API Integration: Your Guide to Seamless Connections

#programming #database #sql #mysql
1
Comments
4 min read
Indexes in MySQL: How long do you wait before calling an index "unused"?
drupaladmin profile

Indexes in MySQL: How long do you wait before calling an index "unused"?

#mysql #webdev #database #sql
5
Comments
1 min read
Mastering Dynamic SQL Operations with the Strategy Pattern: Generate and Execute Commands Across Databases in C#
auyeungdavid_2847435260 profile

Mastering Dynamic SQL Operations with the Strategy Pattern: Generate and Execute Commands Across Databases in C#

#mysql #postgressql #sqlserver #csharp
6
Comments
4 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System
meenakshi052003 profile

SQL IQ – Advanced SQL Interview Queries Search and Prep System

#programming #webdev #mysql #sql
1
Comments 1
4 min read
How to Count Daily Records with MySQL
ypdev19 profile

How to Count Daily Records with MySQL

#mysql #database #learning #webdev
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.