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.
AI DBA on Bare Metal: Slow Log In, Diagnosis + Fix SQL Out (Data Never Leaves Your Network)

Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle Submission đź’¸

AI DBA on Bare Metal: Slow Log In, Diagnosis + Fix SQL Out (Data Never Leaves Your Network)

Comments
4 min read
AWS RDS MySQL kill transaction by ID (without thread_id)

AWS RDS MySQL kill transaction by ID (without thread_id)

Comments
6 min read
Laravel Query Optimization: 4 Simple Fixes for Faster Apps

Laravel Query Optimization: 4 Simple Fixes for Faster Apps

Comments 1
7 min read
Unknown character set index for field received from server

Unknown character set index for field received from server

Comments
6 min read
BeanCreationException: Database Type NONE MySQL Fix

BeanCreationException: Database Type NONE MySQL Fix

Comments
11 min read
Find the Query from query_id in MySQL (InnoDB)

Find the Query from query_id in MySQL (InnoDB)

Comments
8 min read
How to select multiple columns based on a condition in SQL?

How to select multiple columns based on a condition in SQL?

Comments
11 min read
What Is the Host Parameter in mysqli_connect()?

What Is the Host Parameter in mysqli_connect()?

Comments
12 min read
Constraints in PostgreSQL

Constraints in PostgreSQL

Comments
5 min read
MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

Comments
9 min read
Building a Custom Staff Attendance System: A Web Developer's Case Study

Building a Custom Staff Attendance System: A Web Developer's Case Study

Comments
2 min read
How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

Comments
4 min read
Laravel Queues: Redis vs Database Driver

Laravel Queues: Redis vs Database Driver

Comments
12 min read
How to Fix SQLSTATE[HY000] [2002] Connection Refused in Laravel

How to Fix SQLSTATE[HY000] [2002] Connection Refused in Laravel

Comments
7 min read
Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes

Instant ADD COLUMN, Until a FULLTEXT Index Shows Up: A MariaDB Migration That Froze Writes

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.