500 error on phpmyadmin export on /phpmyadmin/export.php
In this post, I will let you know the solution of exporting database from phpmyadmin. This error occurs when you have updated your PHP version, phpmy...
READ MOREHow to upgrade MySQL 5.5 to MySQL 5.7 on Ubuntu 14.04
In this tutorial, I will tell you how to upgrade your MySQL version on Ubuntu in simple steps. This is very simple guide to upgrade version of MySQL...
READ MOREEnable MySQL’s slow query log without a restart
In this post, I will tell you how to enable MySQL’s slow query log to see which query takes longer to execute. This is happen because of coding mis...
READ MORE
What are the main differences between INNODB and MYISAM
the main differences between INNODB and MYISAM The most commonly used storage engine in MySQL are MyISAM and InnoDB. With these storage engine there...
READ MOREDelete multiple records from MySQL in PHP with checkbox
As we know, Its very time consuming to delete records one by one. Everyone wants to delete bulk record on single event only. So here i will tell you...
READ MORE
Submit PHP Bootstrap Form without Page Refresh using jQuery, Ajax
Submit PHP Bootstrap Form into MySQL table without Page Refresh using jQuery, Ajax AJAX (Asynchronous JavaScript and XML) is known as developer's dre...
READ MOREMySQL query to copy data from one column to another column
In this post i will tell you how to copy data from one column to another column in same table. There is simple query to update record from one to ano...
READ MOREPHP MySQLi prepared statement select multiple rows
In this post, i will tell you how to use MySQLi prepared statement to select or fetch multiple rows. As you know very well that by using MySQLi prepa...
READ MOREWhat is MySQLi? What does it do?
MySQLi is improved version of MySQL. Before MySQLi we were using its old version MySQL and millions number of projects have been developed using PHP...
READ MORE
Insert Data into MySQL Database
Insert Data into MySQL DatabaseSQL INSERT INTO statement are used to insert record in MySQL tables.Let's write a MySQL query to insert data by using i...
READ MORE