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.
Day 3 of SQL Series || Basic Commands

Day 3 of SQL Series || Basic Commands

6
Comments
3 min read
End Of Series: SQL Injection Detect & Defend

End Of Series: SQL Injection Detect & Defend

5
Comments 1
1 min read
🚀 Day 6: Notes & Activity Log Module
Cover image for 🚀 Day 6: Notes & Activity Log Module

🚀 Day 6: Notes & Activity Log Module

Comments
2 min read
Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

5
Comments
3 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
MySQL Daemon Overview and Tools
Cover image for MySQL Daemon Overview and Tools

MySQL Daemon Overview and Tools

Comments
1 min read
🚀 Day 5: Sales Tracking Module in CRM
Cover image for 🚀 Day 5: Sales Tracking Module in CRM

🚀 Day 5: Sales Tracking Module in CRM

Comments
2 min read
How I Solved the "MySQL Shutdown Unexpectedly" Error: A Step-by-Step Guide
Cover image for How I Solved the "MySQL Shutdown Unexpectedly" Error: A Step-by-Step Guide

How I Solved the "MySQL Shutdown Unexpectedly" Error: A Step-by-Step Guide

Comments
2 min read
Building a Bible Publication Engine

Building a Bible Publication Engine

1
Comments
2 min read
🚀 Day 4: Lead & Opportunities Module and Analytics with Dynamic Charts
Cover image for 🚀 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
Cover image for 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 🌟
Cover image for 🚀 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
Cover image for How We Simplified Schema & SQL Query Optimization

How We Simplified Schema & SQL Query Optimization

Comments
2 min read
Connecting to a MySQL Database in PHP
Cover image for Connecting to a MySQL Database in PHP

Connecting to a MySQL Database in PHP

Comments
4 min read
🚀 Building a CRM in PHP & MySQL: My Final Year Project Journey 🎓
Cover image for 🚀 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?
Cover image for What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
Cover image for 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
Cover image for Isolation in ACID Transaction

Isolation in ACID Transaction

6
Comments 1
5 min read
Implementation of ACID transaction in Database
Cover image for 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? 😤
Cover image for 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
loading...