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.
Mastering SQL Queries: The 'Format Query for Teacher Salary' Project

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

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
How to Set Up MySQL to Autostart on macOS: A Step-by-Step Guide for Developers

How to Set Up MySQL to Autostart on macOS: A Step-by-Step Guide for Developers

1
Comments
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 Join and Index with Examples

MySQL Basics: Understanding Join and Index with Examples

1
Comments
5 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
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

2
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

4
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

6
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

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

A comprehensive comparison of PostgreSQL and MySQL

5
Comments
7 min read
50x Faster Window Functions? PawSQL's Index Magic Revealed

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

Comments
3 min read
loading...