Learn MySQL by step by step tutorials, best practices and examples. How to install MySQL on Linux, How to change password of user, MySQL and Python, MySQL basics, Joins, CRUD operations, embedded selects, nested update queries, concatenation. MySQL diagrams, MySQL SSH setup, MySQL tools

Python Create a Table in MySQL from Dictionary

In this guide, I'll show you how to create a

Linux Mint 19/Ubuntu 18.04 Access denied for user 'root'@'localhost'

On a fresh installation of Linux Mint 19 and Ubuntu

How to prepare for SQL interview in 2018

Preparing for SQL interview or exam is easy if you

MySQL Useful tips and reference project

MySQL is the most popular DB for several years. Yet

MySQL create, alter and drop table, DB

In previous posts we saw some DML(Data Manipulation Language)

MySQL coalesce, exists, union and having example

Working with SQL requires formatting and filtering of data which

MySQL update, insert, delete examples

In this post we will cover the rest of the

SQL select aggregate functions examples

In this post we will cover most used SQL select

SQL select examples

This is part of tutorial learning SQL from beginners in

MySQL slow query and type conversion

In MySQL you can have query that it's taking much