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 Connect and Query MySQL Data in SSMS

How to Connect and Query MySQL Data in SSMS

Comments
7 min read
Praktikum Keamanan Web: SQL Injection di MySQL & Website PHP 😱🔒🚀

Praktikum Keamanan Web: SQL Injection di MySQL & Website PHP 😱🔒🚀

Comments
3 min read
New to a Large Project? This Is How I Decode Complex Databases

New to a Large Project? This Is How I Decode Complex Databases

1
Comments
2 min read
Building a Multi-Container App using Docker

Building a Multi-Container App using Docker

2
Comments
2 min read
1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
5 Database Query Optimization Tips That Actually Work

5 Database Query Optimization Tips That Actually Work

Comments
1 min read
PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

Comments
4 min read
1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
Developing a PHP Project Across Windows and Mac on Your Home Network

Developing a PHP Project Across Windows and Mac on Your Home Network

Comments
2 min read
Overview of Real-Time Data Synchronization from MySQL to VeloDB

Overview of Real-Time Data Synchronization from MySQL to VeloDB

5
Comments
5 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
How a Cache Invalidation Bug Nearly Took Down Our System - And What We Changed After

How a Cache Invalidation Bug Nearly Took Down Our System - And What We Changed After

Comments 1
4 min read
A (very) Short Look at How MySQL Joins Work

A (very) Short Look at How MySQL Joins Work

2
Comments
2 min read
MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

1
Comments
1 min read
MySQL COUNT Scalar Subquery Optimization: The Complete Guide

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

Comments
4 min read
What’s New At Releem - October 2025

What’s New At Releem - October 2025

Comments
3 min read
I'm Building a LinkedIn Alternative for Developers (And Sharing Everything I Learn)

I'm Building a LinkedIn Alternative for Developers (And Sharing Everything I Learn)

1
Comments
7 min read
Build a Complete Data Pipeline from Scratch: CSV to Dashboard Using Python, MySQL, and Airflow”

Build a Complete Data Pipeline from Scratch: CSV to Dashboard Using Python, MySQL, and Airflow”

2
Comments 1
3 min read
HNG Portal DevOps Technical Documentation

HNG Portal DevOps Technical Documentation

7
Comments
13 min read
Google Cloud SQL: x86 N2 vs ARM C4A

Google Cloud SQL: x86 N2 vs ARM C4A

Comments
7 min read
Remote Database Manager with Visual ER Diagram for MySQL & MS-SQL

Remote Database Manager with Visual ER Diagram for MySQL & MS-SQL

Comments
2 min read
loading...