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.
InnoDB's ibdata1: Essential Management Tips for MySQL

InnoDB's ibdata1: Essential Management Tips for MySQL

Comments
1 min read
How to Install (and Uninstall) MySQL on a Mac

How to Install (and Uninstall) MySQL on a Mac

Comments
7 min read
How to Build a Cloud Application

How to Build a Cloud Application

Comments
35 min read
HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

1
Comments
1 min read
Step-by-step guide for how to install an SQL server on Ubuntu 22.04

Step-by-step guide for how to install an SQL server on Ubuntu 22.04

5
Comments
3 min read
HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

2
Comments
1 min read
NULL Handling in SQL

NULL Handling in SQL

Comments
3 min read
How to Import Excel to MySQL [4-Step Tutorial]

How to Import Excel to MySQL [4-Step Tutorial]

Comments
21 min read
Database Observability: An Introductory Guide

Database Observability: An Introductory Guide

1
Comments
7 min read
HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

1
Comments
1 min read
HackerRank SQL Preparation: Select All(MySQL)

HackerRank SQL Preparation: Select All(MySQL)

1
Comments
1 min read
HackerRank SQL Preparation: Select by ID(MySQL)

HackerRank SQL Preparation: Select by ID(MySQL)

1
Comments
1 min read
Data for World Map Panel Plugin in Grafana from MySQL

Data for World Map Panel Plugin in Grafana from MySQL

Comments
4 min read
All about MySQL

All about MySQL

1
Comments 1
3 min read
Migration of a Workload running in a Corporate Data Center to AWS using the Amazon EC2 and RDS service

Migration of a Workload running in a Corporate Data Center to AWS using the Amazon EC2 and RDS service

Comments
5 min read
optimize query in laravel and mysql

optimize query in laravel and mysql

1
Comments
2 min read
SQL Report Builder

SQL Report Builder

Comments
2 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
The Intricacies of Null Values in MySQL

The Intricacies of Null Values in MySQL

Comments
5 min read
Azure SQL vs MySQL: What are the Differences?

Azure SQL vs MySQL: What are the Differences?

Comments
8 min read
Create a User With Access to Only One Schema in CloudSQL

Create a User With Access to Only One Schema in CloudSQL

Comments
2 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS

OLAP: CUBE, ROLLUP, AND GROUPING SETS

Comments
4 min read
How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

Comments
3 min read
Understanding MySQL Query Optimizer: COUNT(id) vs COUNT(*)

Understanding MySQL Query Optimizer: COUNT(id) vs COUNT(*)

5
Comments
2 min read
Beginner's Guide to CRUD Operations in PHP

Beginner's Guide to CRUD Operations in PHP

6
Comments 9
5 min read
mysql: using json data and not hating it

mysql: using json data and not hating it

5
Comments
7 min read
How to restore a Mysql backup with XAMP

How to restore a Mysql backup with XAMP

Comments
1 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
ERROR 1130 (HY000): Host '123.32.23.12' is not allowed to connect to this MySQL server

ERROR 1130 (HY000): Host '123.32.23.12' is not allowed to connect to this MySQL server

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

Python. Automating creation backups of MySQL database.

Comments
4 min read
SQL AGGREGATE FUNCTIONS

SQL AGGREGATE FUNCTIONS

Comments
2 min read
Building a To-Do List Application using Nuxt.js

Building a To-Do List Application using Nuxt.js

Comments
5 min read
How to inject simple dummy data at a large scale in MySQL

How to inject simple dummy data at a large scale in MySQL

10
Comments 1
4 min read
Understanding the Differences Between SQL and MySQL

Understanding the Differences Between SQL and MySQL

2
Comments
3 min read
What is an ORM and when developers should and shouldn't use it

What is an ORM and when developers should and shouldn't use it

7
Comments 2
3 min read
SQL: Get records having min/max value per group

SQL: Get records having min/max value per group

5
Comments 1
2 min read
How to Set Up a MySQL Master-Slave Replication in Docker

How to Set Up a MySQL Master-Slave Replication in Docker

8
Comments 1
4 min read
Mastering the Art of Invisible Indexes in MySQL

Mastering the Art of Invisible Indexes in MySQL

6
Comments 1
3 min read
Effective Annotating of Strace Output for MySQL Performance Troubleshooting

Effective Annotating of Strace Output for MySQL Performance Troubleshooting

Comments
4 min read
MySQL Performance Monitoring and Query Analysis

MySQL Performance Monitoring and Query Analysis

8
Comments 2
5 min read
How We Simplified MySQL Slow Query Analysis

How We Simplified MySQL Slow Query Analysis

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

How to Check MySQL Database and Table Sizes

7
Comments 2
5 min read
INTRODUCTION TO SQL

INTRODUCTION TO SQL

Comments
4 min read
MariaDB Dump Bash-Script

MariaDB Dump Bash-Script

2
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)

3
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.

1
Comments
1 min read
Top 4 Alternatives to MySQL

Top 4 Alternatives to MySQL

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

8 Common SQL Slow Query Statements and How to Optimize Them

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

Oracle SQL vs MySQL: A Comprehensive Comparison

Comments
3 min read
Run MySQL in Docker on Windows

Run MySQL in Docker on Windows

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

WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

2
Comments
2 min read
Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

7
Comments
17 min read
Comment installer et faire tourner mediawiki Avec Xampp

Comment installer et faire tourner mediawiki Avec Xampp

5
Comments
4 min read
Optimizing Relational Databases for Best Performance in MySQL

Optimizing Relational Databases for Best Performance in MySQL

9
Comments 2
8 min read
How I can order the returned results by relevance in mysql or mariadb when I use like statement in where?

How I can order the returned results by relevance in mysql or mariadb when I use like statement in where?

1
Comments 2
1 min read
Quick MySQL Table Creation: A Developer's Guide

Quick MySQL Table Creation: A Developer's Guide

Comments
1 min read
Database referential integrity with Doctrine

Database referential integrity with Doctrine

7
Comments
3 min read
loading...