How to Obtain the Second Distinct Highest Record using SQL?
Question: Write a SQL query to get the second highest salary (distinct) from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | …
Tag: mysql
How to Create a Ranking Page in WordPress Based On GD Star Rating Plugin?
October 10, 2014
implementation, php, programming languages, sql, web programming, webhosting, wordpress
No Comments
The GD Star Rating Plugin is a famous plugin that allows readers (without login or registration) to give scores to articles, posts, pages and even comments. Therefore, it might …
How to Revive Old Posts using PHP and Crontab
September 22, 2014
beginner, code, code library, database, implementation, php, programming languages, sql, web programming, webhosting, wordpress
No Comments
Suppose you have quite a number of decent posts in your blog and you are wondering that if there is a way to post to twitter/facebook (or other social …
Duplicate a MySQL table – Copy Table / Duplicate Database / PHP Script
August 31, 2014
database, DevOps, php, PHP, programming languages, sql, SQL, tricks, web programming
15 Comments
Suppose if you want to copy a Table to another, this can be done in MySQL with two steps. The first one is to copy the table structure, and …
How to Fix MySQL Crash due to OOM Error?
August 23, 2014
apache server, database, DevOps, mysql, MySQL, tricks, Virtual Private Server, webhosting
No Comments
MySQL server stopped due of out of memory exception on Ubuntu VPS As you may know, my three websites are hosted on a VPS starter package from QuickHostUK – …