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.
The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?
jing_li profile

The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

#mysql #database #sql #programming
Comments
5 min read
🚀 āĻ˛ā§‹āĻ•āĻžāĻ˛ āĻ“ā§Ÿā§‡āĻŦ āĻĄā§‡āĻ­ā§‡āĻ˛āĻĒāĻŽā§‡āĻ¨ā§āĻŸā§‡āĻ° āĻœāĻ¨ā§āĻ¯ Docker āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻ•āĻ°ā§‡ MySQL āĻāĻŦāĻ‚ phpMyAdmin āĻ¸ā§‡āĻŸāĻ†āĻĒ āĻ•āĻ°ā§āĻ¨
rafi021 profile

🚀 āĻ˛ā§‹āĻ•āĻžāĻ˛ āĻ“ā§Ÿā§‡āĻŦ āĻĄā§‡āĻ­ā§‡āĻ˛āĻĒāĻŽā§‡āĻ¨ā§āĻŸā§‡āĻ° āĻœāĻ¨ā§āĻ¯ Docker āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻ•āĻ°ā§‡ MySQL āĻāĻŦāĻ‚ phpMyAdmin āĻ¸ā§‡āĻŸāĻ†āĻĒ āĻ•āĻ°ā§āĻ¨

#webdev #mysql #phpmyadmin #php
Comments
1 min read
How to Create a New MySQL User and Grant All Permissions
msnmongare profile

How to Create a New MySQL User and Grant All Permissions

#mysql #sql #database #programming
Comments
2 min read
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
esproc_spl profile

How to Speed Up EXISTS in Primary-Subtable Joins with esProc

#mysql #development #esproc #database
6
Comments
5 min read
LAMP Development Using Windows Subsystem for Linux (WSL)
jmcscript profile

LAMP Development Using Windows Subsystem for Linux (WSL)

#apache #php #mysql #linux
2
Comments 1
8 min read
EXPLAIN It! Your Fast Track to Fixing Slow SQL
jing_li profile

EXPLAIN It! Your Fast Track to Fixing Slow SQL

#mysql #sql #programming
Comments
8 min read
How to get Bitcoin data and save it in MySQL using Spring Boot
shelner profile

How to get Bitcoin data and save it in MySQL using Spring Boot

#bitcoin #mysql #springboot
Comments 1
4 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc
esproc_spl profile

How to Speed Up Associations between Large Primary and Sub Tables with esProc

#mysql #sql #devops #esproc
7
Comments 1
4 min read
What is the `DECIMAL` type in MySQL?
shelner profile

What is the `DECIMAL` type in MySQL?

#mysql
Comments
1 min read
MySQL Tutorial: A Complete Guide to Mastering Database Management
pythontutorial profile

MySQL Tutorial: A Complete Guide to Mastering Database Management

#mysql #sql #tutorial #mysqltutorial
2
Comments
3 min read
Best MySQL Database Design Tools in 2025
roxana_haidiner profile

Best MySQL Database Design Tools in 2025

#mysql #database #designtools #databasemanagement
11
Comments 2
8 min read
SQL And PHP: People whose birthday is today
benkhalife profile

SQL And PHP: People whose birthday is today

#oop #database #mysql #mariadb
Comments
1 min read
Is the database setup for small project development too complicated?
xianzs profile

Is the database setup for small project development too complicated?

#mysql #python #sqlite #programmers
Comments
1 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!
jing_li profile

Slow SQL? Diagnose & Fix Bottlenecks Fast!

#mysql #database #sql #postgres
Comments
6 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization
drupaladmin profile

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

#mysql #database #devops #webdev
1
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.