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.
100 Days of DevOps: Day 18

100 Days of DevOps: Day 18

Comments
2 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
Day 4 Data Analytics Progress 📈

Day 4 Data Analytics Progress 📈

Comments
1 min read
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
Install and configure Zabbix 7 with Apache and MySQL for Ubuntu 24.04 LTS

Install and configure Zabbix 7 with Apache and MySQL for Ubuntu 24.04 LTS

Comments
3 min read
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

Comments
2 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
MariaDB Vs MySQL: Key Differences You Should Know

MariaDB Vs MySQL: Key Differences You Should Know

Comments
1 min read
How to Delete a Foreign Key in SQL (Step-by-Step Guide)

How to Delete a Foreign Key in SQL (Step-by-Step Guide)

Comments
1 min read
Debug Smarter, Not Harder — Releem Now Shows EXPLAIN Plans and Query Examples for MySQL & MariaDB

Debug Smarter, Not Harder — Releem Now Shows EXPLAIN Plans and Query Examples for MySQL & MariaDB

Comments
2 min read
MyDrive - Personal File Manager

MyDrive - Personal File Manager

Comments
1 min read
🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

Comments
4 min read
How I Built a Complete Invoice Management API with Spring Boot

How I Built a Complete Invoice Management API with Spring Boot

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

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

5
Comments
1 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Comments
2 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

Comments
2 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System

SQL IQ – Advanced SQL Interview Queries Search and Prep System

1
Comments
4 min read
How to Solve MySQL and Redis Cache Inconsistency Like a Pro

How to Solve MySQL and Redis Cache Inconsistency Like a Pro

7
Comments
2 min read
Implementing Transactional Tests with MySQL

Implementing Transactional Tests with MySQL

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

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

5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

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

1
Comments
10 min read
What is Error Code 1451 in MySQL

What is Error Code 1451 in MySQL

Comments
1 min read
loading...