Forem

# 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.
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
Cover image for Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
How to Delete a Foreign Key in SQL (Step-by-Step Guide)
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 🚀 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
Cover image for 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
Cover image for 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 Joins Explained - INNER, LEFT, RIGHT, FULL
Cover image for SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 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
Create MySQL ER Diagrams with a Free Design Tool
Cover image for Create MySQL ER Diagrams with a Free Design Tool

Create MySQL ER Diagrams with a Free Design Tool

6
Comments
4 min read
Building a Simple SQL Parser in Python: From Basics to Hands-On
Cover image for Building a Simple SQL Parser in Python: From Basics to Hands-On

Building a Simple SQL Parser in Python: From Basics to Hands-On

Comments 1
8 min read
Implementing Transactional Tests with MySQL
Cover image for 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
Cover image for 🛠️ 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
Integrating Python with MySQL Databases: An Introduction and Practical Guide
Cover image for Integrating Python with MySQL Databases: An Introduction and Practical Guide

Integrating Python with MySQL Databases: An Introduction and Practical Guide

Comments
12 min read
SQL DATABASE
Cover image for SQL DATABASE

SQL DATABASE

Comments
1 min read
SQL Tricks: Generate Calendar Table

SQL Tricks: Generate Calendar Table

Comments
5 min read
How to Count Daily Records with MySQL
Cover image for How to Count Daily Records with MySQL

How to Count Daily Records with MySQL

Comments
1 min read
How to Duplicate Rows in MySQL

How to Duplicate Rows in MySQL

Comments
2 min read
loading...