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 ComparisionFrom 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 PHPEvery 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 optimizationIt 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 FilesIF 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 SQLIf 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 SQLThis 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