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 | | …
Category: mysql
Secure the Linux Server by Disallow the Remote Root Login (SSH and FTP and MySQL database)
November 13, 2014
apache server, database, DevOps, FTP, linux, mysql, MySQL, security, SSH, Ubuntu, ubuntu, Virtual Private Server, webhosting
No Comments
In this post, we know how important the security is. If you manage your server (VPS, cloud hosting or dedicated server), then you must have root access. The root …
How To Add a Virtual Host on Apache2 Under Ubuntu Server?
October 5, 2014
beginner, dns, linux, mysql, Virtual Private Server, webhosting, wordpress
2 Comments
Today, I decided to move the last domain hosted on Fasthosts shared server (steakovercooked.com) to QuickHostUK. I have paid a 2 year contract and there is still one year …
Bash Script to Check, Repair, Optimise and Backup MySQL database
I have a VPS (Virtual Private Server) and I have just move another domain (steakovercooked.com) onto this. I find it useful to have a script that can automatically check, …
How to Display Top 20 Comment-ed Articles in WordPress?
October 4, 2014
code, implementation, mysql, programming languages, web programming, webhosting, wordpress
1 Comment
Many bloggers use WordPress (The Famous and Recommended Content Management System CMS) nowadays. WordPress has a inbuilt comment system so that the readers can engage in the discussions. The …