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

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

Oracle SQL vs MySQL: A Comprehensive Comparison

2
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
Azure SQL vs MySQL: What are the Differences?

Azure SQL vs MySQL: What are the Differences?

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

OLAP: CUBE, ROLLUP, AND GROUPING SETS

3
Comments 1
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?

1
Comments
3 min read
Optimizing Relational Databases for Best Performance in MySQL

Optimizing Relational Databases for Best Performance in MySQL

10
Comments 2
8 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
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

7
Comments
2 min read
mysql: using the slow query log

mysql: using the slow query log

3
Comments 1
5 min read
How to assign the foreign key in the existing table.

How to assign the foreign key in the existing table.

Comments
2 min read
Why are foreign keys and primary keys used in databases?

Why are foreign keys and primary keys used in databases?

Comments
2 min read
Automate the Deployment of a LAMP Stack & Laravel App with a Script and Ansible

Automate the Deployment of a LAMP Stack & Laravel App with a Script and Ansible

5
Comments 1
20 min read
Installing and Configuring MySQL on Arch Linux

Installing and Configuring MySQL on Arch Linux

49
Comments 2
2 min read
How to solve Unknown variable 'default-authentication-plugin' in Laradock

How to solve Unknown variable 'default-authentication-plugin' in Laradock

1
Comments
1 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

2
Comments
1 min read
Getting Started with Prometheus Alerting

Getting Started with Prometheus Alerting

9
Comments 2
4 min read
INTRODUCTION TO SQL

INTRODUCTION TO SQL

1
Comments 2
4 min read
SQL DATA MANIPULATION

SQL DATA MANIPULATION

2
Comments
3 min read
Replacing Planetscale

Replacing Planetscale

Comments
8 min read
loading...