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.
MySQL in PHP - how to deal with databases

MySQL in PHP - how to deal with databases

10
Comments 3
4 min read
SQL: Timestamps

SQL: Timestamps

41
Comments 4
2 min read
How to Reset MySql Root password on MacOS 10.13

How to Reset MySql Root password on MacOS 10.13

6
Comments
2 min read
MySQL DB backup using Bash script

MySQL DB backup using Bash script

14
Comments 3
1 min read
How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

8
Comments
12 min read
How to Backup MySQL Database using mysqldump

How to Backup MySQL Database using mysqldump

8
Comments
1 min read
Using Python to create MySQL tables with random schema

Using Python to create MySQL tables with random schema

5
Comments
1 min read
MySQL tip of the day: getting rid of the results formatting on the CLI

MySQL tip of the day: getting rid of the results formatting on the CLI

6
Comments
2 min read
How to spin MySQL server with Docker and Docker Compose (plus Adminer)

How to spin MySQL server with Docker and Docker Compose (plus Adminer)

24
Comments 2
3 min read
Making the advanced query filter with Eloquent Filter in Laravel

Making the advanced query filter with Eloquent Filter in Laravel

44
Comments 20
4 min read
PHP and MySQL 30: query select

PHP and MySQL 30: query select

6
Comments
3 min read
PHP and MySQL 20: query insert

PHP and MySQL 20: query insert

6
Comments
3 min read
PHP and MySQL 11: connection to database

PHP and MySQL 11: connection to database

7
Comments
3 min read
PHP and MySQL 10: connection

PHP and MySQL 10: connection

8
Comments
3 min read
Simple MySQL with Elixir

Simple MySQL with Elixir

7
Comments
2 min read
Understanding MySQL Index Basics

Understanding MySQL Index Basics

9
Comments 5
2 min read
[Resolved] MySQL lock wait timeout dealing with Laravel queues and jobs

[Resolved] MySQL lock wait timeout dealing with Laravel queues and jobs

11
Comments 2
3 min read
Best Practice for Creating Indexes on your MySQL Tables

Best Practice for Creating Indexes on your MySQL Tables

39
Comments
4 min read
Dockerizing a Flask-MySQL app with docker-compose

Dockerizing a Flask-MySQL app with docker-compose

32
Comments 2
5 min read
Database designer for web developers and beginner

Database designer for web developers and beginner

15
Comments
2 min read
Monitor your LEMP server with Netdata

Monitor your LEMP server with Netdata

90
Comments 4
6 min read
Project Spotlight - Introducing KikCMS

Project Spotlight - Introducing KikCMS

4
Comments
6 min read
.Net Core 3 + EFCore

.Net Core 3 + EFCore

14
Comments 2
4 min read
How to access MySQL DB behind two ssh host using MySQL Workbench

How to access MySQL DB behind two ssh host using MySQL Workbench

7
Comments
1 min read
How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

5
Comments
13 min read
How I Build a MySql plugin for QT5 (Windows, MinGW32)

How I Build a MySql plugin for QT5 (Windows, MinGW32)

7
Comments
2 min read
Backups with rdiff-backup and mysqldump

Backups with rdiff-backup and mysqldump

8
Comments
2 min read
📚 Awesome links from dev.to and around the web #2

📚 Awesome links from dev.to and around the web #2

44
Comments
2 min read
Spring Embedded MySQL Server

Spring Embedded MySQL Server

6
Comments
4 min read
PHP as a Pain Reliever

PHP as a Pain Reliever

8
Comments
4 min read
.Net Core 3 - Part 2 - MySQL

.Net Core 3 - Part 2 - MySQL

16
Comments 1
3 min read
Flexible data types with the JSON field

Flexible data types with the JSON field

10
Comments
5 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

6
Comments
3 min read
How to Transfer MySQL Databases

How to Transfer MySQL Databases

5
Comments
1 min read
How to get the list of all the affected columns in a SQL query

How to get the list of all the affected columns in a SQL query

7
Comments 1
1 min read
Install and setup Apache + MySQL + PHP on Windows

Install and setup Apache + MySQL + PHP on Windows

14
Comments 3
3 min read
How to access the MySQL CLI With MAMP

How to access the MySQL CLI With MAMP

21
Comments 4
1 min read
Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

23
Comments 5
5 min read
A simple user permission model for sophisticated systems

A simple user permission model for sophisticated systems

14
Comments
14 min read
Add a LAMP Stack to a server with Centos OS

Add a LAMP Stack to a server with Centos OS

8
Comments 2
2 min read
A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

69
Comments 12
10 min read
Why I don't use a database for my blog

Why I don't use a database for my blog

7
Comments 1
4 min read
Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

8
Comments
1 min read
Improve query performance for polymorphic relationships in Laravel

Improve query performance for polymorphic relationships in Laravel

8
Comments
3 min read
How To Install WordPress with a Managed Database on Ubuntu 18.04

How To Install WordPress with a Managed Database on Ubuntu 18.04

34
Comments 8
17 min read
Query Optimization with MySQL

Query Optimization with MySQL

10
Comments
7 min read
Moving from MySQL 5.7 to MariaDB 10.1

Moving from MySQL 5.7 to MariaDB 10.1

6
Comments
7 min read
Playing with Django Models

Playing with Django Models

22
Comments 1
10 min read
Understanding timezones

Understanding timezones

11
Comments
1 min read
Advanced usage of yum-config-manager with setopts

Advanced usage of yum-config-manager with setopts

8
Comments 5
1 min read
How to automatically backup MYSQL to Amazon S3?

How to automatically backup MYSQL to Amazon S3?

11
Comments 3
3 min read
Form Processing in CFScript Part Two: Saving Form Entries to the Database

Form Processing in CFScript Part Two: Saving Form Entries to the Database

9
Comments
4 min read
How to Setup a WordPress MySQL Database in the Cloud

How to Setup a WordPress MySQL Database in the Cloud

3
Comments
10 min read
C#言語APIメモ

C#言語APIメモ

4
Comments
1 min read
A Basic MySQL Tutorial

A Basic MySQL Tutorial

7
Comments
2 min read
To do or not to do, whats more good of a practice.

To do or not to do, whats more good of a practice.

5
Comments 5
1 min read
PHP MySQLi Library Pt2

PHP MySQLi Library Pt2

4
Comments
4 min read
PHP MySQL Library Pt3

PHP MySQL Library Pt3

5
Comments
2 min read
what is better to remove a column or make it null in MySQL.

what is better to remove a column or make it null in MySQL.

8
Comments 4
1 min read
How to write optional filters in SQL

How to write optional filters in SQL

10
Comments
1 min read
loading...