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.
SEMESTER PROJECT DEMO

SEMESTER PROJECT DEMO

6
Comments
1 min read
Add Social Login in Laravel With Socialite

Add Social Login in Laravel With Socialite

6
Comments
2 min read
Use Advanced MySQL Operations to Analyze Python Web Scraper Data

Use Advanced MySQL Operations to Analyze Python Web Scraper Data

2
Comments
13 min read
MySQL: Understanding EXPLAIN

MySQL: Understanding EXPLAIN

3
Comments
6 min read
MySQL Shell: the best tool for your logical backups

MySQL Shell: the best tool for your logical backups

17
Comments 4
12 min read
Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 3

Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 3

8
Comments
1 min read
Create a Netflix clone from Scratch: JavaScript PHP + MySQL

Create a Netflix clone from Scratch: JavaScript PHP + MySQL

105
Comments 8
2 min read
Want to convert any SQL Query to Mongo DB Query - Shortcut

Want to convert any SQL Query to Mongo DB Query - Shortcut

3
Comments
1 min read
Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 2:How to get most out of the course

Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 2:How to get most out of the course

6
Comments
1 min read
Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 1:Download & Installation

Create a Netflix clone from Scratch: JavaScript PHP + MySQL Day 1:Download & Installation

9
Comments 1
1 min read
How To Layer a GraphQL API on a MySQL Database With a Single Command

How To Layer a GraphQL API on a MySQL Database With a Single Command

4
Comments
4 min read
How I solved SQL to Redis caching with Go

How I solved SQL to Redis caching with Go

20
Comments
1 min read
Visualizing Sales Data with Arctype Dashboards

Visualizing Sales Data with Arctype Dashboards

5
Comments
7 min read
What is the sorting algorithm behind ORDER BY query in MySQL?

What is the sorting algorithm behind ORDER BY query in MySQL?

6
Comments
4 min read
MySQL pagination

MySQL pagination

6
Comments
2 min read
Boost your Laravel models by Lara Query Kit

Boost your Laravel models by Lara Query Kit

5
Comments
3 min read
SQL Injection vs. Your Applications in the Modern Age

SQL Injection vs. Your Applications in the Modern Age

7
Comments
7 min read
Using MySQL with Docker

Using MySQL with Docker

4
Comments
1 min read
Bulk Update Multiple Records with Separate Data — Laravel

Bulk Update Multiple Records with Separate Data — Laravel

30
Comments 4
2 min read
Create your own `upsert` method

Create your own `upsert` method

10
Comments
3 min read
Transaction Isolation Levels In Innodb

Transaction Isolation Levels In Innodb

8
Comments
3 min read
Data Modelling / Database Design

Data Modelling / Database Design

17
Comments 1
3 min read
Indexing MySQL For High Performance: A High-level Overview

Indexing MySQL For High Performance: A High-level Overview

5
Comments
6 min read
Laravel Scout & Elasticsearch: Scout flush does not delete all records

Laravel Scout & Elasticsearch: Scout flush does not delete all records

2
Comments
1 min read
MySQL query default value is query is NULL

MySQL query default value is query is NULL

2
Comments
1 min read
Create Custom Database Module in NestJS with TypeORM MySQL/PostgreSQL

Create Custom Database Module in NestJS with TypeORM MySQL/PostgreSQL

6
Comments 1
3 min read
Backend Developers Desired

Backend Developers Desired

2
Comments
1 min read
MySQL database management using the terminal

MySQL database management using the terminal

5
Comments
2 min read
Securing the connectivity between a GKE application and a Cloud SQL database

Securing the connectivity between a GKE application and a Cloud SQL database

9
Comments 1
10 min read
Securing sensitive data in Cloud SQL

Securing sensitive data in Cloud SQL

5
Comments
3 min read
Move a MySQL Database from one host to another using Terminal

Move a MySQL Database from one host to another using Terminal

6
Comments 1
3 min read
Canal+Kafka, a Fancy Way To Sync MySQL to Redis in Real-Time

Canal+Kafka, a Fancy Way To Sync MySQL to Redis in Real-Time

2
Comments
1 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

26
Comments 9
3 min read
Use MySQL Window Functions to Get More out of Your Data

Use MySQL Window Functions to Get More out of Your Data

5
Comments
11 min read
HOW TO SLOW "(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

HOW TO SLOW "(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

5
Comments
1 min read
How i prevent SQL Injection in my PHP code

How i prevent SQL Injection in my PHP code

7
Comments 2
3 min read
How to parse JSON data from server to Android

How to parse JSON data from server to Android

7
Comments
4 min read
Setting up your own High Availability managed WordPress hosting using Amazon RDS

Setting up your own High Availability managed WordPress hosting using Amazon RDS

3
Comments 2
8 min read
Golang REST API with Domain Driven Design

Golang REST API with Domain Driven Design

14
Comments 1
4 min read
Search UTF8mb4 text of MySQL in PHP

Search UTF8mb4 text of MySQL in PHP

2
Comments
1 min read
How To Check mysqldump character-set

How To Check mysqldump character-set

2
Comments
1 min read
Cascade deleting in Prisma (v2)

Cascade deleting in Prisma (v2)

5
Comments
2 min read
How To connect Laravel Application to MySQL Database.

How To connect Laravel Application to MySQL Database.

50
Comments 3
2 min read
How to properly retrieve Laravel models between two dates

How to properly retrieve Laravel models between two dates

79
Comments 3
5 min read
SQL Or NOSQL: That is the question!

SQL Or NOSQL: That is the question!

5
Comments
5 min read
How to add single quote in SQL query string

How to add single quote in SQL query string

2
Comments
2 min read
Connect to MySQL

Connect to MySQL

6
Comments
1 min read
Figuring out a verification system via email link

Figuring out a verification system via email link

5
Comments 1
4 min read
Blog with Go, Gin, MySQL and Docker - Part 2

Blog with Go, Gin, MySQL and Docker - Part 2

20
Comments 1
9 min read
6 Easy steps for sharing AWS Encrypted RDS snapshot between two accounts.

6 Easy steps for sharing AWS Encrypted RDS snapshot between two accounts.

8
Comments
3 min read
MYSQL Operator: A MYSQL ❤ affair with Kubernetes

MYSQL Operator: A MYSQL ❤ affair with Kubernetes

Comments
5 min read
Multi-Tier Architecture on AWS EKS using Terraform

Multi-Tier Architecture on AWS EKS using Terraform

3
Comments 2
2 min read
Laravel 8.x withExists Method to Eloquent Queries Example

Laravel 8.x withExists Method to Eloquent Queries Example

4
Comments 4
1 min read
Blog Project with Go, Gin, MySQL and Docker - Part 1

Blog Project with Go, Gin, MySQL and Docker - Part 1

52
Comments 5
8 min read
How Install WordPress with Docker

How Install WordPress with Docker

21
Comments 3
1 min read
Sequelize and MySQL debugging quick tips

Sequelize and MySQL debugging quick tips

9
Comments 3
4 min read
Big Data + MySQL = Mission InnoPossible?

Big Data + MySQL = Mission InnoPossible?

4
Comments
9 min read
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
loading...