MySql Archive

Database Searching Techniques with MySQL

In this article, we will learn about basic Database Searching Techniques with MySQL. Search box most important element on web pages specially content management sites. When it comes to implementation search box, you want that people should get correct results as per their searching terms or keywords. In this post I will explain very basic

Enable slow query log in MySQL

This post will explains how to enable slow query log in MySQL. Slow query log helps in optimizing the long query and hence it improves application performance in good amount. Since it’s not recommended to keep enable slow query on server, because it slow down the performance of application. You can enable slow query log

Difference between MyISAM and InnoDB

Difference between MyISAM and InnoDB In this article, we will get know of Difference between MyISAM and InnoDB. MYISAM: MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS MyISAM stores its tables, data and indexes in diskspace using separate three different

Difference between MySQL and MySQLi

Difference between MySQL and MySQLi MySQL is the old database driver, and MySQLi is the Improved driver. MySQLi takes advantage of the newer features of MySQL 5.Difference between MySQL and MySQLi Object-oriented interface Support for Prepared Statements Support for Multiple Statements Support for Transactions Enhanced debugging capabilities Embedded server support Useful link http://php.net/manual/en/mysqli.overview.php