How to delete sleeping processes in Mysql

Whenever a new query executed, a freash process st


Deploying Codeigniter project from local to live server

Here I am sharing how you can deploy your CodeIgni


PHPMyAdmin: deleting all rows from MySql table

Basically, you can delete rows in MySQL


PhpMyAdmin: No activity within 1440 seconds, please log in again!!!

If you do not do any activity in your PH


Finding nearest location using latitude and longitude.

Here I am explaining how you can find nearest lati


Mysql Event scheduler

I have already posted a blog (Event Scheduler an a


Mysql varchar max length

Maximum data what we can store in varchar in mysql


Mysql error due to reserve words in query.

Sometime it happens, you create field name or tabl


Generating ERD using PHPMyAdmin

Today I need to generate ERD for my Database. If y


How to access remote mysql server using local phpmyadmin

It is very tedious to connect your remote mysql bo


Different ways to find 2nd highest salary from employee table

"Most Common Question in Interview, how to get 2nd


Maximum Number of Columns Per Table - Mysql

Maximum we can have 4096 columns per table, but


Mysql Event Scheduler an alternative to cronjob.

Mysql introduce Event scheduler which we can use a


Mysql Query : Nth highest salary from employee table

"Most Common Question in Interview, how to get 2nd


Example to use variable in Mysql

After a long time i used variable in SQL queries.


How Mysql reduce overhead from PHP!!!!!

I enjoy to play with Mysql queries. what i learn f


MySql Function Between.. AND in LEFT JOIN

MySql Function Between.. AND in LEFT JOIN If


Implementation of User permission with PHP & Mysql Bitwise operators.

Another way to implement user permission in your a


Maximum Number of Columns Per Table - Mysql

Maximum we can have 4096 columns per table, but ex


PHP-Mysql Interview Questions

Some PHP interview question i am sharing with you,