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.
Recreate mysql database from frm files and idb

Recreate mysql database from frm files and idb

4
Comments
2 min read
Spinning up MySQL Database with Docker

Spinning up MySQL Database with Docker

15
Comments
2 min read
MariaDB Quick-tip #5 - Create a sequence of date and time

MariaDB Quick-tip #5 - Create a sequence of date and time

9
Comments 2
2 min read
ERROR #1093 : You can't specify target table table_name for update in FROM clause

ERROR #1093 : You can't specify target table table_name for update in FROM clause

10
Comments
3 min read
WEB STACK IMPLEMENTATION (LAMP STACK) IN AWS

WEB STACK IMPLEMENTATION (LAMP STACK) IN AWS

6
Comments
9 min read
MariaDb Quick-tip #4 - Random int for each row

MariaDb Quick-tip #4 - Random int for each row

Comments
1 min read
Install Nginx, PHP 8.0, WordPress, and MySQL on Ubuntu

Install Nginx, PHP 8.0, WordPress, and MySQL on Ubuntu

7
Comments 1
9 min read
Laravel : Query Comma Separated Column using Eloquent and MySQL find_in_set

Laravel : Query Comma Separated Column using Eloquent and MySQL find_in_set

3
Comments
1 min read
Testcontainers with MySQL and Redis with an Spring Boot Kotlin Application

Testcontainers with MySQL and Redis with an Spring Boot Kotlin Application

31
Comments 8
8 min read
MariaDB Quick-tip #3 - Prepending zeros

MariaDB Quick-tip #3 - Prepending zeros

7
Comments
1 min read
Self-Host your own Ghost Blog

Self-Host your own Ghost Blog

7
Comments
3 min read
MariaDB Quick-tip #1 - Range of int

MariaDB Quick-tip #1 - Range of int

8
Comments 2
1 min read
I Could Not Run a Sample Code to Use MySQL with Go on Docker (Error 1064)

I Could Not Run a Sample Code to Use MySQL with Go on Docker (Error 1064)

8
Comments
3 min read
Deploy Spring Boot application to AWS Elastic Beanstalk and RDS

Deploy Spring Boot application to AWS Elastic Beanstalk and RDS

8
Comments
2 min read
Guide to Dockerize your Spring Boot application with MySQL database

Guide to Dockerize your Spring Boot application with MySQL database

38
Comments 1
3 min read
MySQL module for NestJS 8.x/9.x/10.x framework 😻

MySQL module for NestJS 8.x/9.x/10.x framework 😻

10
Comments
6 min read
A Complete Guide to Generated Columns in MySQL

A Complete Guide to Generated Columns in MySQL

16
Comments
7 min read
How to provision database using AWS RDS for your next application

How to provision database using AWS RDS for your next application

3
Comments
2 min read
MariaDB Quick-tip #2 - Randomize rows

MariaDB Quick-tip #2 - Randomize rows

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

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

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

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

7
Comments
6 min read
Explain Combining Domain-Driven Design and Databases

Explain Combining Domain-Driven Design and Databases

7
Comments
8 min read
Как установить MySql на домашнею ubuntu

Как установить MySql на домашнею ubuntu

2
Comments
1 min read
Wait, I changed my mind.

Wait, I changed my mind.

14
Comments 3
5 min read
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

14
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

13
Comments 7
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)

9
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 ?

40
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

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

10
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

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

11
Comments
4 min read
Java and MySQL

Java and MySQL

5
Comments
7 min read
loading...