How to delete sleeping processes in Mysql

Whenever a new query executed, a freash

Posted by Suresh Kamrushi on April 03, 2018

Deploying Codeigniter-3 project from local to live server

Here I am sharing how you can deploy your Codeigni

Posted by Suresh Kamrushi on November 05, 2018

PHPMyAdmin: deleting all rows from MySql table

  Basically, you can delete rows in MySQL ta

Posted by Suresh Kamrushi on October 20, 2017

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

  If you do not do any activity in your PHPM

Posted by Suresh Kamrushi on August 04, 2017

Finding nearest location using latitude and longitude.

Here I am explaining how you can find nearest lati

Posted by Suresh Kamrushi on August 12, 2015

Mysql Event scheduler

I have already posted a blog (Event Scheduler an a

Posted by Suresh Kamrushi on September 18, 2016

Mysql varchar max length

Maximum data what we can store in varchar in mysql

Posted by Suresh Kamrushi on July 07, 2015

Mysql error due to reserve words in query.

Sometime it happens, you create field name or tabl

Posted by Suresh Kamrushi on October 18, 2016

Generating ERD using PHPMyAdmin

Generating ERD using PHPMyAdmin 4.0 (Newer Version

Posted by Suresh Kamrushi on March 05, 2014

How to access remote mysql server using local phpmyadmin

It is very tedious to connect your remote mysql bo

Posted by Suresh Kamrushi on February 28, 2014

Different ways to find 2nd highest salary from employee table

Most Common Question in Interview, how to get 2nd

Posted by Suresh Kamrushi on December 15, 2013

Maximum Number of Columns Per Table - Mysql

Maximum we can have 4096 columns per table, but

Posted by Suresh Kamrushi on January 31, 2014

Mysql Event Scheduler an alternative to cronjob.

Mysql introduce Event scheduler which we can use a

Posted by Suresh Kamrushi on January 31, 2014

Mysql Query : Nth highest salary from employee table

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

Posted by Suresh Kamrushi on August 10, 2013

Example to use variable in Mysql

After a long time i used variable in SQL queries.

Posted by Suresh Kamrushi on August 10, 2013

How Mysql reduce overhead from PHP!!!!!

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

Posted by Suresh Kamrushi on August 10, 2013

MySql Function Between.. AND in LEFT JOIN

MySql Function Between.. AND in LEFT JOIN If

Posted by Suresh Kamrushi on August 10, 2013

Implementation of User permission with PHP & Mysql Bitwise operators.

Another way to implement user permission in your a

Posted by Suresh Kamrushi on August 10, 2013

Maximum Number of Columns Per Table - Mysql

Maximum we can have 4096 columns per table, but ex

Posted by Suresh Kamrushi on August 10, 2013

PHP-Mysql Interview Questions

Some PHP interview question i am sharing with you,

Posted by Suresh Kamrushi on August 10, 2013


Categories

Recent Posts

Ads