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:07MySQL MyISAM InnoDB Comparision
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:05MySQL PHP
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:09PHP MySQL Web optimization
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:42PHP MySQL Files
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:47MySQL SQL
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:04MySQL SQL