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.
Memilih Primary Key, INT Auto Increment vs UUID

Memilih Primary Key, INT Auto Increment vs UUID

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
How to Connect React with MySQL (Step by Step Guide)

How to Connect React with MySQL (Step by Step Guide)

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
3 min read
ShannonBase β€” The Next-Gen HTAP Database for the AI Era

ShannonBase β€” The Next-Gen HTAP Database for the AI Era

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
3 min read
SQL Database Concepts:

SQL Database Concepts:

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
1 min read
Primary Key vs. Foreign Key in SQL: Explained with Examples

Primary Key vs. Foreign Key in SQL: Explained with Examples

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices

SQL LIKE Operator: What It Is, How It Works, and Best Practices

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
Stored Procedures: Organization and Code Quality in SQL

Stored Procedures: Organization and Code Quality in SQL

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
Building Altus 4: Why I Created an AI-Enhanced MySQL Search Engine (Instead of Just Using Elasticsearch)

Building Altus 4: Why I Created an AI-Enhanced MySQL Search Engine (Instead of Just Using Elasticsearch)

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
6 min read
HAVING Condition Pushdown: Optimizing Query Performance

HAVING Condition Pushdown: Optimizing Query Performance

2
🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
3 min read
SQL Mini project :WC24 T20 Data Analytics

SQL Mini project :WC24 T20 Data Analytics

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
1 min read
Top 6 MySQL Database Management Struggles for Laravel Developers (And Smart Fixes)

Top 6 MySQL Database Management Struggles for Laravel Developers (And Smart Fixes)

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
7 min read
Brighter: MigraΓ§Γ£o do MySQL Outbox para a V10

Brighter: MigraΓ§Γ£o do MySQL Outbox para a V10

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
5 min read
Brighter: Migrating MySQL outbox to V10

Brighter: Migrating MySQL outbox to V10

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
4 min read
Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Tesla Financial Analysis Dashboard using Python, SQL & Power BI

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
1 min read
MySQL Views & Window Functions: Advanced Data Analysis Techniques

MySQL Views & Window Functions: Advanced Data Analysis Techniques

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
August 2025 At Releemβ€Š-β€ŠRecommendations Impact & Redundant Index Detection

August 2025 At Releemβ€Š-β€ŠRecommendations Impact & Redundant Index Detection

5
🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
MySQL Lab: Building a University Information Query System with Database Views

MySQL Lab: Building a University Information Query System with Database Views

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
Composite Indexes in MySQL

Composite Indexes in MySQL

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
1 min read
Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

6
🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
3 min read
100 Days of DevOps: Day 18

100 Days of DevOps: Day 18

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
2 min read
Day 4 Data Analytics Progress πŸ“ˆ

Day 4 Data Analytics Progress πŸ“ˆ

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
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

🌐 Mysql - DEV CommunityDropdown menuDropdown menuNavigation menuSearchSearchCloseLeft menuRight menuCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsCommentsComments - dev.to
12 min read
loading...