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.
Debug a Slow MySQL Query Before You Guess at Indexes

Debug a Slow MySQL Query Before You Guess at Indexes

13
Comments 2
3 min read
How to Check MySQL Database and Table Sizes

How to Check MySQL Database and Table Sizes

11
Comments 2
5 min read
MariaDB Dump Bash-Script

MariaDB Dump Bash-Script

1
Comments
1 min read
Setting Up MySQL Database in Python

Setting Up MySQL Database in Python

3
Comments
6 min read
MySQL to BigQuery Migration (Syntax & Other Conversions)

MySQL to BigQuery Migration (Syntax & Other Conversions)

Comments
3 min read
Optimizing MySQL Database Performance: Identifying and Managing Long Queries

Optimizing MySQL Database Performance: Identifying and Managing Long Queries

1
Comments
4 min read
Python. Exploring MySQL Table Sizes.

Python. Exploring MySQL Table Sizes.

2
Comments
1 min read
Top 4 Alternatives to MySQL

Top 4 Alternatives to MySQL

Comments
5 min read
Inside SQL Joins

Inside SQL Joins

2
Comments
4 min read
LOGIN SYSTEM IN PHP AND MYSQL: User Authentication system.

LOGIN SYSTEM IN PHP AND MYSQL: User Authentication system.

1
Comments 1
2 min read
Python. Automating creation backups of MySQL database.

Python. Automating creation backups of MySQL database.

3
Comments
4 min read
Python code that inserts a large number of records into a MySQL table.

Python code that inserts a large number of records into a MySQL table.

Comments
2 min read
8 Common SQL Slow Query Statements and How to Optimize Them

8 Common SQL Slow Query Statements and How to Optimize Them

8
Comments
7 min read
Oracle SQL vs MySQL: A Comprehensive Comparison

Oracle SQL vs MySQL: A Comprehensive Comparison

2
Comments
3 min read
WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

2
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.