Difference between MySQL storage engines InnoDB and MyISAM

MySQL supported storage engines are, MyISAM InnoDB Memory CSV Merge Archive Federated Blackhole And, Most commonly using storage engines are InnoDB and MyISAM. Let see the Difference between them in the following table,   Inno..

Read More » Posted on 2016-08-26 08:20:07

MySQL MyISAM InnoDB Comparision

MySQL Multiple timestamp column with CURRENTTIMESTAMP in One table

From MySQL version 5.6.+ allow to add multiple timestamp datatype column and can set Default as CURRENT_TIMESTAMP Previous versions of MySQL allow to add multiple timestamp datatype column but NOT..

Read More » Posted on 2016-06-14 06:51:05

MySQL PHP

PHP Page Views Count Example

Every website or blog is needed page count to show the top visiting pages. It helps visitors to look around the interesting posts and for analysis. Some methods are..

Read More » Posted on 2016-05-29 08:55:09

PHP MySQL Web optimization

PHP Image or Video duplicate check with MySQL

It is easier to check duplicate or changed file like images, videos, text files and so on. Syntax $sha_hash = sha1_file(file_path); sha1_file() is using the US Secure Hash Algorithm 1 it..

Read More » Posted on 2016-04-17 05:35:42

PHP MySQL Files

MySQL If Else condition in Select

IF Else condition in query is quite interesting and it is very useful in some cases. It reduces two queries to single one. Syntax IF(Statement, TRUE block, FALSE block) It works like usual If Else condition..

Read More » Posted on 2016-04-09 03:52:47

MySQL SQL

MySQL If Else condition in Where clause

If Else is slightly similar to OR condition in MySQL. But, here it checks the Statement and go to TRUE Block or FALSE Block. Syntax WHERE IF(Statement, TRUE block, FALSE block) Example Here is the..

Read More » Posted on 2016-04-06 03:12:04

MySQL SQL

MySQL Increment value by N

This is a simple query to increment row value in MySQL. And this eliminates the need of code in php or other server side scripts. Syntax UPDATE tablename SET column_name=column_name + N where clause..

Read More » Posted on 2016-04-05 03:01:27

MySQL SQL