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.
🚀 Day 4: Lead & Opportunities Module and Analytics with Dynamic Charts

🚀 Day 4: Lead & Opportunities Module and Analytics with Dynamic Charts

Comments
2 min read
Essential MySQL Operators and Their Applications

Essential MySQL Operators and Their Applications

Comments
2 min read
📹 How YouTube Scaled MySQL to Support 2.49 Billion Users 🚀

📹 How YouTube Scaled MySQL to Support 2.49 Billion Users 🚀

1
Comments
3 min read
🚀 My CRM Journey(Day-2): Admin Panel, jQuery Integration & Customer Management 🌟

🚀 My CRM Journey(Day-2): Admin Panel, jQuery Integration & Customer Management 🌟

1
Comments
3 min read
Running MySQL Server in Docker

Running MySQL Server in Docker

Comments
1 min read
How We Simplified Schema & SQL Query Optimization

How We Simplified Schema & SQL Query Optimization

Comments
2 min read
🚀 Building a CRM in PHP & MySQL: My Final Year Project Journey 🎓

🚀 Building a CRM in PHP & MySQL: My Final Year Project Journey 🎓

Comments
4 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

35
Comments 7
4 min read
Day 2 of SQL Series || Basic Commands

Day 2 of SQL Series || Basic Commands

9
Comments
3 min read
Best Practices for Handling Sensitive Data in MySQL Databases

Best Practices for Handling Sensitive Data in MySQL Databases

Comments 1
4 min read
Isolation in ACID Transaction

Isolation in ACID Transaction

6
Comments 1
5 min read
Implementation of ACID transaction in Database

Implementation of ACID transaction in Database

5
Comments
3 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

33
Comments 9
13 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Comments
5 min read
Safe Database Migration: Converting MySQL Enum to String in Laravel

Safe Database Migration: Converting MySQL Enum to String in Laravel

1
Comments 3
3 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
Simplify Data Migration Between Databases Using DbVisualizer

Simplify Data Migration Between Databases Using DbVisualizer

1
Comments
1 min read
Fixing the 'MySQL Module Shutting Down Unexpectedly' Error in XAMPP: Step-by-Step Guide

Fixing the 'MySQL Module Shutting Down Unexpectedly' Error in XAMPP: Step-by-Step Guide

2
Comments
2 min read
Boost Your MySQL Debugging Skills with the General Query Log

Boost Your MySQL Debugging Skills with the General Query Log

Comments
4 min read
How to choose the right database?

How to choose the right database?

Comments
4 min read
Create a Relational Database Application

Create a Relational Database Application

5
Comments
3 min read
Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

5
Comments 1
3 min read
Part 7: SQL Injection Series: Advanced SQL Injection Techniques

Part 7: SQL Injection Series: Advanced SQL Injection Techniques

5
Comments 1
4 min read
How to Fix "MySQL Shutdown Unexpectedly"

How to Fix "MySQL Shutdown Unexpectedly"

4
Comments
2 min read
loading...