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.
Add multiple columns after a column in Laravel Migrations

Add multiple columns after a column in Laravel Migrations

2
Comments
1 min read
Migrating My Heroku-Based SaaS to Heroku Postgres

Migrating My Heroku-Based SaaS to Heroku Postgres

5
Comments
6 min read
PlanetScale CLI Basics

PlanetScale CLI Basics

15
Comments
5 min read
Launching WordPress With MySQL Database in K8S Cluster On AWS Using Ansible!

Launching WordPress With MySQL Database in K8S Cluster On AWS Using Ansible!

3
Comments
2 min read
The database for developers is here

The database for developers is here

18
Comments 4
1 min read
Designing a database with MySQL using the Command Line Interface — Part 1

Designing a database with MySQL using the Command Line Interface — Part 1

7
Comments
10 min read
Solución a ERROR #1115: Unknown character set: utf8mb4

Solución a ERROR #1115: Unknown character set: utf8mb4

1
Comments
2 min read
How to fetch the data from database

How to fetch the data from database

1
Comments
1 min read
Why do database columns have a character length of 191?

Why do database columns have a character length of 191?

23
Comments 2
5 min read
How I handled the scalability of the SQL database in Inspector

How I handled the scalability of the SQL database in Inspector

1
Comments
5 min read
Setting Up Lumen and MySQL With Docker - Part II

Setting Up Lumen and MySQL With Docker - Part II

3
Comments
3 min read
How to get the raw SQL query from the Laravel Query Builder

How to get the raw SQL query from the Laravel Query Builder

2
Comments
2 min read
Spring Boot, Hibernate, MySQL example: CRUD app

Spring Boot, Hibernate, MySQL example: CRUD app

23
Comments
4 min read
#LaravelWiki

#LaravelWiki

3
Comments
1 min read
Can I use MySQL with Node.js?

Can I use MySQL with Node.js?

7
Comments 3
4 min read
Why did my Java Web App stop working with MySQL!?!

Why did my Java Web App stop working with MySQL!?!

6
Comments 4
3 min read
MariaDB: Update database charset / collation

MariaDB: Update database charset / collation

6
Comments
1 min read
How to make the most out of #100DaysOfCode

How to make the most out of #100DaysOfCode

7
Comments
3 min read
Understanding 'Cursor' in SQL

Understanding 'Cursor' in SQL

4
Comments 1
1 min read
Deploying your Laravel + MySQL application on Heroku

Deploying your Laravel + MySQL application on Heroku

33
Comments 8
7 min read
ການເຮັດ Automated mysql backup ຢ່າງງ່າຍ!

ການເຮັດ Automated mysql backup ຢ່າງງ່າຍ!

4
Comments
2 min read
What is Stored Procedure in SQL

What is Stored Procedure in SQL

6
Comments
1 min read
Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL

Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL

7
Comments
11 min read
Building Web Applications using Beego + Mysql+ORM

Building Web Applications using Beego + Mysql+ORM

6
Comments
3 min read
Installing MySQL on MacOS

Installing MySQL on MacOS

4
Comments
2 min read
How to Run Sequelize Migrations in Azure Pipelines

How to Run Sequelize Migrations in Azure Pipelines

2
Comments
6 min read
Database lock MySQL | MySQL Tutorial For Beginners

Database lock MySQL | MySQL Tutorial For Beginners

2
Comments
1 min read
What is ACID? Baby don't hurt me. No more.

What is ACID? Baby don't hurt me. No more.

10
Comments 1
4 min read
The untold truth I learned about frameworks

The untold truth I learned about frameworks

24
Comments 4
9 min read
Popular string functions in MySQL - Replace and Reverse

Popular string functions in MySQL - Replace and Reverse

4
Comments
1 min read
Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

3
Comments
2 min read
FastAPI project template (jWT, MariaDB)

FastAPI project template (jWT, MariaDB)

6
Comments
1 min read
Powering Real-Time Analytics at Scale on MySQL and PostgreSQL

Powering Real-Time Analytics at Scale on MySQL and PostgreSQL

3
Comments
5 min read
Collaborative Filtering in MySQL: A Tutorial

Collaborative Filtering in MySQL: A Tutorial

1
Comments
5 min read
Getting Started with Rails & TiDB

Getting Started with Rails & TiDB

6
Comments
3 min read
SQL Review - Useful queries for mySQL

SQL Review - Useful queries for mySQL

9
Comments
1 min read
MySQL - Transaction Isolation Levels

MySQL - Transaction Isolation Levels

2
Comments
1 min read
Introduction to MySQL replication

Introduction to MySQL replication

17
Comments 3
7 min read
MongoDB Vs. MySQL For Beginners

MongoDB Vs. MySQL For Beginners

11
Comments 6
2 min read
Difference between `count(*)` and `count(column_name)`

Difference between `count(*)` and `count(column_name)`

3
Comments
1 min read
How I Learned to Stop Worrying and Love NULL in SQL

How I Learned to Stop Worrying and Love NULL in SQL

2
Comments
5 min read
Connecting MySQL Database to Python Flask Application

Connecting MySQL Database to Python Flask Application

10
Comments 2
3 min read
How To Build a GraphQL API Connected to a MySQL Database Using StepZen

How To Build a GraphQL API Connected to a MySQL Database Using StepZen

13
Comments
6 min read
mysqldump Best Practices: Part 2 - Migrations Guide

mysqldump Best Practices: Part 2 - Migrations Guide

2
Comments
5 min read
Upload images with React, ExpressJS and mySQL

Upload images with React, ExpressJS and mySQL

68
Comments 7
5 min read
Using Docker secrets with MySQL in Docker Compose

Using Docker secrets with MySQL in Docker Compose

6
Comments
2 min read
SQL Review - GROUP BY Query

SQL Review - GROUP BY Query

7
Comments 3
2 min read
How to use MySQL/Postgres with Docker

How to use MySQL/Postgres with Docker

8
Comments
2 min read
Build REST API with Laravel

Build REST API with Laravel

3
Comments
1 min read
Eager Loading with Selected Columns in Laravel

Eager Loading with Selected Columns in Laravel

2
Comments
1 min read
Eloquent ORM (Object Relational Mapping) in Laravel

Eloquent ORM (Object Relational Mapping) in Laravel

2
Comments
1 min read
Running MongoDB, Redis, MySQL, and NATS as a Docker container

Running MongoDB, Redis, MySQL, and NATS as a Docker container

9
Comments
1 min read
phpMyAdmin Alternatives (Web based SQL Client)

phpMyAdmin Alternatives (Web based SQL Client)

2
Comments
1 min read
Deno Rest APIs CRUD mysql

Deno Rest APIs CRUD mysql

9
Comments
3 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

6
Comments
2 min read
React Redux & MySQL: CRUD example with Node.js Express

React Redux & MySQL: CRUD example with Node.js Express

26
Comments
5 min read
Mysql 5.7 Window Functions Workaround

Mysql 5.7 Window Functions Workaround

9
Comments
3 min read
How To Import Data From an Excel File To Your Database(MySQL) using PHPMyAdmin.

How To Import Data From an Excel File To Your Database(MySQL) using PHPMyAdmin.

9
Comments 1
2 min read
Deploying An Asp.Net Core WebApi and MySql DataBase Container to Azure Kubernetes Service

Deploying An Asp.Net Core WebApi and MySql DataBase Container to Azure Kubernetes Service

9
Comments
5 min read
Integrating Azure and Confluent: Real-Time Search Powered by Azure Cache for Redis, Spring Cloud

Integrating Azure and Confluent: Real-Time Search Powered by Azure Cache for Redis, Spring Cloud

14
Comments
13 min read
loading...