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.
Creating a CRUD Application with PHP, MySQL, and Lithe

Creating a CRUD Application with PHP, MySQL, and Lithe

6
Comments 4
5 min read
Create a Booking Database In 3 Steps

Create a Booking Database In 3 Steps

Comments
17 min read
Criando uma Aplicação CRUD com PHP, MySQL e Lithe

Criando uma Aplicação CRUD com PHP, MySQL e Lithe

8
Comments 2
6 min read
Tutorial Install MySQL / MariaDB di Linux Ubuntu

Tutorial Install MySQL / MariaDB di Linux Ubuntu

Comments
2 min read
MySQL Optimize Tips

MySQL Optimize Tips

1
Comments
3 min read
Optimizing SQL Queries

Optimizing SQL Queries

2
Comments
5 min read
Essential Guide to MySQL Subqueries

Essential Guide to MySQL Subqueries

Comments
1 min read
SQL || MySQL || By Munisekhar Udavalapati

SQL || MySQL || By Munisekhar Udavalapati

1
Comments
2 min read
Building a Simple CRUD Application with PHP and MySQL

Building a Simple CRUD Application with PHP and MySQL

11
Comments 5
3 min read
SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL

SQL Sequelize || By Munisekhar Udavalapati || MySQL || SQL

1
Comments 4
1 min read
50x Faster Window Functions? PawSQL's Index Magic Revealed

50x Faster Window Functions? PawSQL's Index Magic Revealed

Comments
3 min read
Mastering MySQL Aggregate Functions: Simplifying Data Analysis

Mastering MySQL Aggregate Functions: Simplifying Data Analysis

Comments
4 min read
Why MySQL is the Superior Choice for Database Management Over MS Access

Why MySQL is the Superior Choice for Database Management Over MS Access

Comments 1
6 min read
Xampp MY-SQL running out 😐

Xampp MY-SQL running out 😐

Comments
2 min read
How to import excel into mysql only 1 step

How to import excel into mysql only 1 step

Comments
2 min read
Create an Attendance Database In 3 Steps

Create an Attendance Database In 3 Steps

1
Comments
16 min read
Generate ER Diagrams in MYSQL workbench

Generate ER Diagrams in MYSQL workbench

1
Comments 1
2 min read
Unlock Your Database Skills: 'Add Student Personal Information' Project

Unlock Your Database Skills: 'Add Student Personal Information' Project

Comments
2 min read
A Deep Dive Into MySQL Monitoring: What Is Aborted Clients and Why It Matters

A Deep Dive Into MySQL Monitoring: What Is Aborted Clients and Why It Matters

2
Comments
3 min read
SQL 101: Introduction to Structured Query Language

SQL 101: Introduction to Structured Query Language

Comments 1
3 min read
Laravel SoftDelete: Avoiding the Unique Constraint Problem

Laravel SoftDelete: Avoiding the Unique Constraint Problem

5
Comments
5 min read
SQL(Structured Query Language) Road Map for beginners

SQL(Structured Query Language) Road Map for beginners

6
Comments 2
2 min read
Understanding OLTP and Choosing the Right Database

Understanding OLTP and Choosing the Right Database

1
Comments
6 min read
Why I Revisited MS SQL Server Basics: A Deep Dive into String Data Types

Why I Revisited MS SQL Server Basics: A Deep Dive into String Data Types

Comments
3 min read
🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques

🚀 Boosting TPC-H Q2 Query Performance by 1000x times: PawSQL Optimization Techniques

2
Comments
4 min read
MySQL + Docker: Initial Setup

MySQL + Docker: Initial Setup

1
Comments
3 min read
The Ultimate Guide to Data Analytics: A Deep Dive into Data Engineering

The Ultimate Guide to Data Analytics: A Deep Dive into Data Engineering

Comments
6 min read
Mastering SQL Queries: The 'Format Query for Teacher Salary' Project

Mastering SQL Queries: The 'Format Query for Teacher Salary' Project

1
Comments
3 min read
How to Create a Robust Ubuntu Web Server Using Apache, MySQL, PHP, and Virtual Hosts

How to Create a Robust Ubuntu Web Server Using Apache, MySQL, PHP, and Virtual Hosts

3
Comments 1
3 min read
MySQL Basics: Understanding Isolation Level and Transaction Anomalies

MySQL Basics: Understanding Isolation Level and Transaction Anomalies

1
Comments
4 min read
MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples

MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples

Comments
5 min read
Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project

Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project

1
Comments
3 min read
Smaller, Free Database Providers I've Found

Smaller, Free Database Providers I've Found

1
Comments
1 min read
PostgreSQL vs MySQL: A Concise Comparison

PostgreSQL vs MySQL: A Concise Comparison

Comments
2 min read
3 things to consider migrating WordPress database from local to production

3 things to consider migrating WordPress database from local to production

1
Comments
2 min read
MySQL User Permissions: A Practical Guide

MySQL User Permissions: A Practical Guide

1
Comments
3 min read
Comprehensive SQL Project: Mastering Database Manipulation

Comprehensive SQL Project: Mastering Database Manipulation

Comments
3 min read
Understanding the Decimal Datatype in MySQL

Understanding the Decimal Datatype in MySQL

Comments
2 min read
MySQL View Creation | Data Manipulation | Database Management

MySQL View Creation | Data Manipulation | Database Management

Comments
3 min read
Setup Redmine on Docker Container

Setup Redmine on Docker Container

2
Comments
3 min read
How Do You Integrate PHP with MySQL for Database Management?

How Do You Integrate PHP with MySQL for Database Management?

Comments
2 min read
MySQL won't start because of AppArmor

MySQL won't start because of AppArmor

Comments
1 min read
Fuzzy Matching with Trigram Search: Building Intelligent Search in Node.js and MySQL

Fuzzy Matching with Trigram Search: Building Intelligent Search in Node.js and MySQL

1
Comments
2 min read
Database Sharding in MySQL: A Comprehensive Guide

Database Sharding in MySQL: A Comprehensive Guide

5
Comments
5 min read
How to Connect Java Database Connectivity with MySQL in Visual Studio Code on macOS

How to Connect Java Database Connectivity with MySQL in Visual Studio Code on macOS

3
Comments
3 min read
MySQL Challenges: Mastering Database Concepts and Skills

MySQL Challenges: Mastering Database Concepts and Skills

Comments
3 min read
Optimizing Aurora MySQL Storage by Deleting Unnecessary Data

Optimizing Aurora MySQL Storage by Deleting Unnecessary Data

4
Comments 1
3 min read
IN vs EXISTS in SQL: Understanding Performance and Usage

IN vs EXISTS in SQL: Understanding Performance and Usage

1
Comments
3 min read
Migrate Your Local MySQL Database to AWS RDS

Migrate Your Local MySQL Database to AWS RDS

8
Comments
4 min read
A comprehensive comparison of PostgreSQL and MySQL

A comprehensive comparison of PostgreSQL and MySQL

5
Comments
7 min read
18 Key Points You Must Know When Creating Tables in MySQL

18 Key Points You Must Know When Creating Tables in MySQL

6
Comments
11 min read
Dockerizing a Golang API with MySQL and adding Docker Compose Support

Dockerizing a Golang API with MySQL and adding Docker Compose Support

81
Comments 14
6 min read
Calling SQL Developers for assist

Calling SQL Developers for assist

Comments
1 min read
Understanding MySQL CPU Usage: Tools and Techniques

Understanding MySQL CPU Usage: Tools and Techniques

2
Comments
8 min read
Essential MtSQL 50 Selected Practice Questions with Answers

Essential MtSQL 50 Selected Practice Questions with Answers

Comments
13 min read
How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

Comments
4 min read
ChatBot Project

ChatBot Project

Comments 1
1 min read
Build a Database Schema In 5 Steps

Build a Database Schema In 5 Steps

Comments
26 min read
Unlock MySQL Performance: Mastering Query Cache Optimization

Unlock MySQL Performance: Mastering Query Cache Optimization

Comments 2
8 min read
Can MySQL Support 10000 of Concurrent Connections Without a Performance Collapse in Low-Conflict Scenarios Like TPC-C Testing?

Can MySQL Support 10000 of Concurrent Connections Without a Performance Collapse in Low-Conflict Scenarios Like TPC-C Testing?

2
Comments
7 min read
loading...