There are many times you need to concatenate the values of two or more columns while querying the result. To concatenate columns in MySql there is in-built function for that.
-
Related Posts (YARPP)
-
Topics
-
-
MyISAM vs InnoDB. What’s the difference between MyISAM and InnoDB storage engine. No doubt, MySql is one of the most used databases worldwide. The great thing about MySql is the flexibility to choose storage engines.
In MySql, every storage engine is designed for a specific purpose to address/solve application problems. The two popular storage engines of MySql (MyISAM and InnoDB) are widely used worldwide. So let’s check what’s the difference between MyISAM and InnoDB storage engines.
PHP provides three api to connect mysql Database.
1. MySql
2. MySqli
3. PDO
Out of these three MySql extension is deprecated as of PHP 5.5.0, and will be removed in the future.
MYSQLI is an improved object oriented extension introduced in PHP 5.