difference between strstr and stristr in php

Both function return substring, find the first occurrence of and return the rest of the string, main difference is that STRSTR() is case sensitive and STRISTR() is insensitive STRSTR $str = “sadanada singh Chauhan is the same as sadananda chauhan”; echo strstr($str,’chauhan’); OUTPUT:-chauhan STRISTR $str = “sadanada singh Chauhan is the same as sadananda chauhan”; ...

What is use of normalization in database?

15. March 2017 Mysql 0
Normalization used to reduce data redundancy and improve data integrity. Normalization and Anomalies:- Anomalies:- Tables having redundant data known as anomalies, redundancy is the dublication of the data. Three Type of Anomalies:- 1)Insert Anomaly 2)Delete Anomaly 3)Update Anomaly Normalization:- This is database design technique to reduce data redundancy using different normal form 1st NF, 2nd ...

Different storage Engines Feature Summary

14. December 2016 Mysql 0
Feature MyISAM Memory InnoDB Archive NDB Storage limits 256TB RAM 64TB None 384EB Transactions No No Yes No Yes Locking granularity Table Table Row Row Row MVCC No No Yes No No Geospatial data type support Yes No Yes Yes Yes Geospatial indexing support Yes No Yes[a] No No B-tree indexes Yes Yes Yes No ...