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.
🚀 Building a CRM in PHP & MySQL: My Final Year Project Journey 🎓
anticoder03 profile

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

#php #webdev #mysql #productivity
Comments
4 min read
What Are Stored Procedures?
jing_li profile

What Are Stored Procedures?

#database #sql #mysql
Comments
8 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
grahamthedev profile

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

#mysql #sql #webdev #programming
35
Comments 7
4 min read
Day 2 of SQL Series || Basic Commands
akshat0610 profile

Day 2 of SQL Series || Basic Commands

#sql #tutorial #beginners #mysql
9
Comments
3 min read
Best Practices for Handling Sensitive Data in MySQL Databases
adityabhuyan profile

Best Practices for Handling Sensitive Data in MySQL Databases

#mysql #sensitivedata
Comments 1
4 min read
Isolation in ACID Transaction
jaiminbariya profile

Isolation in ACID Transaction

#database #mysql #postgres #webdev
6
Comments 1
5 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤
grahamthedev profile

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

#mysql #webdev #sql #programming
34
Comments 9
13 min read
Implementation of ACID transaction in Database
jaiminbariya profile

Implementation of ACID transaction in Database

#mysql #database #postgres #webdev
5
Comments
3 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON
adityabhuyan profile

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

#sql #mysql #json #bestpractices
Comments
5 min read
Safe Database Migration: Converting MySQL Enum to String in Laravel
bhaidar profile

Safe Database Migration: Converting MySQL Enum to String in Laravel

#laravel #php #mysql #migration
1
Comments 3
3 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance
sshamza profile

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

#relational #sql #mysql #webdev
Comments
3 min read
Simplify Data Migration Between Databases Using DbVisualizer
dbvismarketing profile

Simplify Data Migration Between Databases Using DbVisualizer

#migration #mysql #postgres
1
Comments
1 min read
Fixing the 'MySQL Module Shutting Down Unexpectedly' Error in XAMPP: Step-by-Step Guide
harshchaudhari profile

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

#mysql #xampp #errorfix #webdev
2
Comments
2 min read
Boost Your MySQL Debugging Skills with the General Query Log
drupaladmin profile

Boost Your MySQL Debugging Skills with the General Query Log

#webdev #devops #mysql #database
Comments
4 min read
Database Normalization
aryaglekshmi profile

Database Normalization

#database #sql #postgres #mysql
2
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.