How to Generate 100K Test Data to MySQL Database?
If you want to test the performance of the SQL statements or just want to test the Database performance, you will need to generate lots of records in a …
Category: mysql
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 …
How to Get Popular Posts of the Year using SQL? (2015)
At the end of each year, as a blogger, you might be interested in knowing the list of top popular posts of the year. Luckily, this can be easily …
Better SQL Insert Syntax
The SQL Insert statement is used when you want to insert new rows of data into the existing tables. For example, if a table has fields A, B, C …