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 Triggers

MySQL Triggers

6
Comments
3 min read
How to create 2 MySQL DBs in a single container?

How to create 2 MySQL DBs in a single container?

8
Comments
1 min read
Deal Scoring- Part 1: Data Pre-processing in MySQL

Deal Scoring- Part 1: Data Pre-processing in MySQL

8
Comments
2 min read
Postgres Vs MySQL syntax comparison with cheatsheet

Postgres Vs MySQL syntax comparison with cheatsheet

6
Comments
1 min read
Learn MySQL Now!

Learn MySQL Now!

8
Comments
1 min read
How To Update Or Insert A Record In Spring Data JPA

How To Update Or Insert A Record In Spring Data JPA

9
Comments 6
2 min read
Generating reports and KPIs with throw-away databases on AWS

Generating reports and KPIs with throw-away databases on AWS

17
Comments
5 min read
Top 11 MYSQL monitoring tools in 2022 [open-source included]

Top 11 MYSQL monitoring tools in 2022 [open-source included]

32
Comments
7 min read
Databases Migrations

Databases Migrations

9
Comments
5 min read
Making a local MicroK8s environment available externally (Part 2 - Installing MicroK8s and MySQL)

Making a local MicroK8s environment available externally (Part 2 - Installing MicroK8s and MySQL)

8
Comments
5 min read
Laravel 9 - Create Column after Another Column

Laravel 9 - Create Column after Another Column

9
Comments
1 min read
Long Live MySQL: Kudos to the Ecosystem Innovators

Long Live MySQL: Kudos to the Ecosystem Innovators

5
Comments
9 min read
List the size of the database and tables: MySQL CLI

List the size of the database and tables: MySQL CLI

9
Comments
1 min read
MySQL's Data Streaming : What is it & How it works ?

MySQL's Data Streaming : What is it & How it works ?

30
Comments
10 min read
Spring Boot CRUD API, Amazon RDS for MySQL, AWS Secrets Manager - example

Spring Boot CRUD API, Amazon RDS for MySQL, AWS Secrets Manager - example

9
Comments
5 min read
To Run Services After Deploying The MariaDB Service Using Docker Compose

To Run Services After Deploying The MariaDB Service Using Docker Compose

6
Comments
3 min read
🔗PythonMysql_Connection

🔗PythonMysql_Connection

10
Comments
2 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 2

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 2

7
Comments
9 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 1

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 1

5
Comments
9 min read
Recreating MYSQL's LPAD Function in SQL Server

Recreating MYSQL's LPAD Function in SQL Server

7
Comments 2
4 min read
Introducing prosql.io!

Introducing prosql.io!

12
Comments 3
2 min read
[error] [mysql] 1251

[error] [mysql] 1251

8
Comments
1 min read
Howto handle index key specification without a key length and key was too long

Howto handle index key specification without a key length and key was too long

7
Comments
4 min read
Migrate from PostgreSQL to MySQL using Slick (Scala)

Migrate from PostgreSQL to MySQL using Slick (Scala)

6
Comments
2 min read
Failed to Install mariadb-server Fedora35?

Failed to Install mariadb-server Fedora35?

5
Comments
1 min read
How to add Dropbox to XAMPP using an Alias

How to add Dropbox to XAMPP using an Alias

6
Comments
2 min read
Amazon RDS - MySQL for .NET Developers

Amazon RDS - MySQL for .NET Developers

6
Comments
5 min read
SQL Interview Questions CheatSheet

SQL Interview Questions CheatSheet

9
Comments 2
7 min read
Laravel, MySQL - column_type is set to "int (11)" even though the size of int was specified.

Laravel, MySQL - column_type is set to "int (11)" even though the size of int was specified.

9
Comments 4
2 min read
Long Live MySQL: Good Old MySQL Should Be Rejuvenated

Long Live MySQL: Good Old MySQL Should Be Rejuvenated

9
Comments
8 min read
Node.js MySQL vs Node.js MySQL + Sculter.js (which one is better?)

Node.js MySQL vs Node.js MySQL + Sculter.js (which one is better?)

9
Comments 2
3 min read
Connect your Java application with any SQL databases

Connect your Java application with any SQL databases

11
Comments
4 min read
Cara membuat MariaDB/MySQL bisa diakses secara remote di Ubuntu 18.04

Cara membuat MariaDB/MySQL bisa diakses secara remote di Ubuntu 18.04

6
Comments
1 min read
Multiple MySQL Router Client in Single Server/Nodes

Multiple MySQL Router Client in Single Server/Nodes

6
Comments
2 min read
Cara Import Dan Export Table Database Mysql

Cara Import Dan Export Table Database Mysql

7
Comments
1 min read
Understanding XA Transactions With Practical Examples in Go

Understanding XA Transactions With Practical Examples in Go

9
Comments
4 min read
Java and MySQL

Java and MySQL

6
Comments
7 min read
Solve Phantom Read in MySQL

Solve Phantom Read in MySQL

9
Comments 2
5 min read
How Install MySQL and Workbench on Windows

How Install MySQL and Workbench on Windows

5
Comments
3 min read
100 days of interview questions series!

100 days of interview questions series!

6
Comments
1 min read
บันทึก: การย้าย database และ laravel storage ไปเครื่องใหม่

บันทึก: การย้าย database และ laravel storage ไปเครื่องใหม่

7
Comments
1 min read
How to Build Node.js REST API with MySQL

How to Build Node.js REST API with MySQL

11
Comments
5 min read
A tool to seed your dev database with real data

A tool to seed your dev database with real data

8
Comments
1 min read
Nested Classes - CustomRowMapper !! Not a Problem Anymore !! - Part 2

Nested Classes - CustomRowMapper !! Not a Problem Anymore !! - Part 2

6
Comments
3 min read
Get a Legacy PHP (5.3) application running in Docker

Get a Legacy PHP (5.3) application running in Docker

10
Comments 1
4 min read
MySQL Join | Types and Examples

MySQL Join | Types and Examples

2
Comments
5 min read
How to store coordinates in MySQL

How to store coordinates in MySQL

12
Comments
2 min read
The Beauty of Open Source

The Beauty of Open Source

6
Comments
2 min read
All MongoDb Database commands (MongoDb Cheatsheet)

All MongoDb Database commands (MongoDb Cheatsheet)

5
Comments
1 min read
Announcing PHPWeekly's 7 Day Book Giveaway

Announcing PHPWeekly's 7 Day Book Giveaway

4
Comments
1 min read
Complete Laravel 8 Soft Delete & Restore Deleted Records Tutorial

Complete Laravel 8 Soft Delete & Restore Deleted Records Tutorial

7
Comments
7 min read
Solving "Index for table 'user' is corrupt; try to repair it"

Solving "Index for table 'user' is corrupt; try to repair it"

6
Comments 1
1 min read
Solutions for storing state in a database

Solutions for storing state in a database

33
Comments 4
4 min read
How to create a delete endpoint with node.js and MySql

How to create a delete endpoint with node.js and MySql

6
Comments
2 min read
How to search a value on a JSON array column with MySQL?

How to search a value on a JSON array column with MySQL?

12
Comments
1 min read
jQuery Datatables Ajax PHP and MySQL using PDO Example

jQuery Datatables Ajax PHP and MySQL using PDO Example

8
Comments
3 min read
Jquery Datatable Example

Jquery Datatable Example

6
Comments
24 min read
How To Use Laravel 8 SQLite Database using Windows

How To Use Laravel 8 SQLite Database using Windows

5
Comments
2 min read
How to Create Model in Laravel 8?

How to Create Model in Laravel 8?

6
Comments
2 min read
Referential Integrity With Sharded Databases

Referential Integrity With Sharded Databases

13
Comments
7 min read
loading...