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

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?

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

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