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.
How to Optimize Database Queries in Laravel?

How to Optimize Database Queries in Laravel?

13
Comments 4
5 min read
Relational Data Services in Azure - PaaS, IaaS, Hybrid & IoT

Relational Data Services in Azure - PaaS, IaaS, Hybrid & IoT

6
Comments
5 min read
Build Pivot Tables in MySQL Using User Variables

Build Pivot Tables in MySQL Using User Variables

3
Comments
6 min read
mysql 101

mysql 101

5
Comments
5 min read
Blog Project with Go, Gin, MySQL and Docker - Part 3

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

12
Comments 3
6 min read
Accessing a RDS Database Locally

Accessing a RDS Database Locally

7
Comments
3 min read
Choose the Best SQL Adapter for Your Python Project

Choose the Best SQL Adapter for Your Python Project

5
Comments
4 min read
Membuat CRUD dengan PHP dan MySQLi

Membuat CRUD dengan PHP dan MySQLi

2
Comments
1 min read
Spring Boot + MYSQL Database with Docker

Spring Boot + MYSQL Database with Docker

11
Comments
2 min read
Sync ES data with your mysql db

Sync ES data with your mysql db

2
Comments
2 min read
Cara Install MySQL di Ubuntu

Cara Install MySQL di Ubuntu

3
Comments
1 min read
DataTables Server-side Processing with PHP and MySQL

DataTables Server-side Processing with PHP and MySQL

2
Comments
1 min read
Beware the Performance Dangers of MySQL Views

Beware the Performance Dangers of MySQL Views

19
Comments 1
4 min read
OAuth 2.0 authentication with Spring Security, Angular and MySql

OAuth 2.0 authentication with Spring Security, Angular and MySql

7
Comments
1 min read
Node.js CRUD Operation with MySQL example

Node.js CRUD Operation with MySQL example

202
Comments 1
4 min read
How many rows would have been there without that LIMIT clause?

How many rows would have been there without that LIMIT clause?

12
Comments
6 min read
Node.js with MySQL database.

Node.js with MySQL database.

62
Comments 7
1 min read
Developing a cost effective alternative to Amazon RDS automatic backups

Developing a cost effective alternative to Amazon RDS automatic backups

8
Comments
5 min read
PHP & MySQL AJAX example Using jQuery

PHP & MySQL AJAX example Using jQuery

35
Comments 2
6 min read
Additional Column for Incremental Numbering in SQL

Additional Column for Incremental Numbering in SQL

7
Comments 2
1 min read
How To Use Bootstrap Datepicker in PHP & MySQL using Ajax

How To Use Bootstrap Datepicker in PHP & MySQL using Ajax

12
Comments
4 min read
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

18
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
loading...