Category: mysql

Given the following SQL Schema: Create table If Not Exists Employee (Id int, Name varchar(255), Department varchar(255), ManagerId int) Truncate table Employee insert into Employee (Id, Name, Department, ManagerId) …

SQL Left Outer Join can be illustrated by the following: where the query will take everything from left table and those fields from the right table. Let’s take a …

Given a Relational Table stroing the nodes in a tree-like data structure, like this: +----+------+ | id | p_id | +----+------+ | 1 | null | | 2 | …

MySQL MyISAM database engine has been depreciated in the latest version since 5.5.1. The MyISAM is table locking while InnoDB (now the default database engine for MySQL since 5.5.1) …

Motivation How many of you sometimes want to know how much you have been paid by writing good contents? Especially for those regular writers or even full time steemians, …