DEV Community

loading...

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

Reactions 6 Comments
2 min read
Archiving large MySQL tables (part I - intro)

Archiving large MySQL tables (part I - intro)

Reactions 9 Comments 4
5 min read
Archiving large MySQL tables (part II - initial migrations)

Archiving large MySQL tables (part II - initial migrations)

Reactions 7 Comments
11 min read
Archiving large MySQL tables (part III - automation)

Archiving large MySQL tables (part III - automation)

Reactions 6 Comments
4 min read
Connect NodeJS App With MySQL Database Hosted on a Digital Ocean Droplet (Server)

Connect NodeJS App With MySQL Database Hosted on a Digital Ocean Droplet (Server)

Reactions 35 Comments 4
2 min read
Docker: MySQL, PostgreSQL, and MongoDB

Docker: MySQL, PostgreSQL, and MongoDB

Reactions 8 Comments
1 min read
Creating a cloud-based Pokédex: overview

Creating a cloud-based Pokédex: overview

Reactions 42 Comments
4 min read
MySQL in PHP - how to deal with databases

MySQL in PHP - how to deal with databases

Reactions 10 Comments 3
4 min read
How to Reset MySql Root password on MacOS 10.13

How to Reset MySql Root password on MacOS 10.13

Reactions 6 Comments
2 min read
MySQL DB backup using Bash script

MySQL DB backup using Bash script

Reactions 13 Comments 3
1 min read
How to Backup MySQL Database using mysqldump

How to Backup MySQL Database using mysqldump

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

Using Python to create MySQL tables with random schema

Reactions 6 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

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

Reactions 21 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

Reactions 34 Comments 19
4 min read
PHP and MySQL 30: query select

PHP and MySQL 30: query select

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

PHP and MySQL 20: query insert

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

PHP and MySQL 11: connection to database

Reactions 7 Comments
3 min read
Understanding MySQL Index Basics

Understanding MySQL Index Basics

Reactions 9 Comments 5
2 min read
Toggle NOT NULL constraint with Rails migration

Toggle NOT NULL constraint with Rails migration

Reactions 9 Comments 1
1 min read
Resolve MySQL lock wait timeout dealing with Laravel queues and jobs

Resolve MySQL lock wait timeout dealing with Laravel queues and jobs

Reactions 10 Comments 2
4 min read
Dockerizing a Flask-MySQL app with docker-compose

Dockerizing a Flask-MySQL app with docker-compose

Reactions 12 Comments 1
5 min read
Monitor your LEMP server with Netdata

Monitor your LEMP server with Netdata

Reactions 90 Comments 4
6 min read
Project Spotlight - Introducing KikCMS

Project Spotlight - Introducing KikCMS

Reactions 4 Comments
6 min read
Database is not always the answer

Database is not always the answer

Reactions 22 Comments 12
2 min read
Backups with rdiff-backup and mysqldump

Backups with rdiff-backup and mysqldump

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

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

Reactions 43 Comments
2 min read
Flexible data types with the JSON field

Flexible data types with the JSON field

Reactions 10 Comments
5 min read
Why using REPLACE INTO might be a bad idea

Why using REPLACE INTO might be a bad idea

Reactions 7 Comments
3 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Reactions 7 Comments
3 min read
How to Transfer MySQL Databases

How to Transfer MySQL Databases

Reactions 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

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

Install and setup Apache + MySQL + PHP on Windows

Reactions 14 Comments 3
3 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)

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

A simple user permission model for sophisticated systems

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

Add a LAMP Stack to a server with Centos OS

Reactions 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

Reactions 52 Comments 11
10 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.

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

Improve query performance for polymorphic relationships in Laravel

Reactions 8 Comments
3 min read
How to automatically backup MYSQL to Amazon S3?

How to automatically backup MYSQL to Amazon S3?

Reactions 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

Reactions 9 Comments
4 min read
[astuce] Comment utiliser une base de donnée pour stocker tous vos logs personnalisés avec l'API JLog de Joomla 3

[astuce] Comment utiliser une base de donnée pour stocker tous vos logs personnalisés avec l'API JLog de Joomla 3

Reactions 4 Comments
1 min read
A Basic MySQL Tutorial

A Basic MySQL Tutorial

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

Reactions 5 Comments 5
1 min read
PHP MySQLi Library Pt2

PHP MySQLi Library Pt2

Reactions 4 Comments
4 min read
PHP MySQL Library Pt3

PHP MySQL Library Pt3

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

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

How to write optional filters in SQL

Reactions 9 Comments
1 min read
PHP MySQLi Library Pt1

PHP MySQLi Library Pt1

Reactions 3 Comments
4 min read
Run MySQL on Docker and use in your Java App

Run MySQL on Docker and use in your Java App

Reactions 18 Comments 8
3 min read
4 MySQL traps

4 MySQL traps

Reactions 51 Comments 2
3 min read
Creating a ZFS Image of a MySQL Data Directory

Creating a ZFS Image of a MySQL Data Directory

Reactions 9 Comments
2 min read
I found a really odd bug on Mysql 8

I found a really odd bug on Mysql 8

Reactions 7 Comments 1
2 min read
The best and easy way to handle database migrations (version control)

The best and easy way to handle database migrations (version control)

Reactions 15 Comments
2 min read
Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

Reactions 21 Comments 2
5 min read
MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

Reactions 9 Comments 2
3 min read
TestRail: QA Test Case Management installation on Linux

TestRail: QA Test Case Management installation on Linux

Reactions 8 Comments
8 min read
Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

Reactions 11 Comments
2 min read
Debugging queries - lazy vs eager loading in Laravel

Debugging queries - lazy vs eager loading in Laravel

Reactions 9 Comments 1
3 min read
Sequelize Model.update

Sequelize Model.update

Reactions 4 Comments 5
1 min read
loading...