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.
gem install mysql2

gem install mysql2

13
Comments
1 min read
pgtop – a top clone for PostgreSQL

pgtop – a top clone for PostgreSQL

6
Comments
3 min read
The Complete mysqldump Guide (with examples)

The Complete mysqldump Guide (with examples)

21
Comments
8 min read
MySQL Errors Messages And Common Problems

MySQL Errors Messages And Common Problems

6
Comments
3 min read
Mini Guide: How to Import a SQL File in MySQL

Mini Guide: How to Import a SQL File in MySQL

2
Comments
2 min read
MySQL replication over SSH

MySQL replication over SSH

6
Comments
3 min read
Connecting to a MySQL database with SQLAlchemy

Connecting to a MySQL database with SQLAlchemy

23
Comments
3 min read
SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

4
Comments 1
1 min read
GCP Cloud SQL Secure connection

GCP Cloud SQL Secure connection

9
Comments
6 min read
PHP - Create your own dotenv to loads environment variables from .env file

PHP - Create your own dotenv to loads environment variables from .env file

89
Comments 7
1 min read
Database Design of a Restaurant Management System from user story to relational Model

Database Design of a Restaurant Management System from user story to relational Model

64
Comments 9
5 min read
How to run PHP and link to MySQL using XAMPP

How to run PHP and link to MySQL using XAMPP

9
Comments 2
2 min read
MySQL 8 Kafka Connect Tutorial on Docker

MySQL 8 Kafka Connect Tutorial on Docker

9
Comments 2
5 min read
Database indexing in Laravel - Everything you need to know

Database indexing in Laravel - Everything you need to know

18
Comments 3
3 min read
What data type should I use in mysql

What data type should I use in mysql

2
Comments 2
1 min read
Exporting a sql database from phpmyadmin and copying it to your local machine when you have lots of foreign key constraints

Exporting a sql database from phpmyadmin and copying it to your local machine when you have lots of foreign key constraints

2
Comments
1 min read
Setup Linux, Apache, MySQL, PHP(LAMP) Stack on Ubuntu 18.04

Setup Linux, Apache, MySQL, PHP(LAMP) Stack on Ubuntu 18.04

18
Comments 2
8 min read
How to draw a relational data model with MySQL workbench on Windows.

How to draw a relational data model with MySQL workbench on Windows.

10
Comments
4 min read
Warnings against using unofficial installers

Warnings against using unofficial installers

6
Comments 12
1 min read
Installation of Mysql in Docker (Ubuntu 18.04)

Installation of Mysql in Docker (Ubuntu 18.04)

6
Comments
2 min read
PHP - Create a QueryBuilder object for the SQL language

PHP - Create a QueryBuilder object for the SQL language

15
Comments 2
1 min read
MSQL Subquery

MSQL Subquery

6
Comments 1
1 min read
Create SQL from CSV files for larger updation or insertion

Create SQL from CSV files for larger updation or insertion

6
Comments
2 min read
How to Install MySQL Workbench and XAMPP on Mac

How to Install MySQL Workbench and XAMPP on Mac

5
Comments
4 min read
Fix PHPMyAdmin Error: requested authentication method unknown to the client [caching_sha2_password]

Fix PHPMyAdmin Error: requested authentication method unknown to the client [caching_sha2_password]

8
Comments 2
1 min read
loading...