How to Determine the Type of Tree Nodes using SQL?
Given a Relational Table stroing the nodes in a tree-like data structure, like this: +----+------+ | id | p_id | +----+------+ | 1 | null | | 2 | …
Tag: mysql
A Simple PHP Command Line Tool to Convert MySQL Tables from MyISAM to InnoDB in Specified Database
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) …
SQL Exercise – How to Swap Columns? (MySQL)
Let’s suppose we have a table containing two columns ID and sex, and our task is to swap the values of sex i.e. from ‘f’ to ‘m’ and from …
Nth Highest Distinct Record using SQL
Write a SQL query to get the nth highest distinct salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 …
How to Automatically Restart MySQL Server in the event of Crash?
MySQL server, due to complex configuration settings, sometimes crashes because of out-of-memory error. In such events, the process will die peacefully and the websites will go down until commands …