MySQL | MySQLIi |
MySQL extension added in PHP version 2.0 and depreacated as of PHP 5.5.0. | MYSQLi extension added in PHP 5.5 and will work on MySQL 4.1.3 or above |
MySQL provides the procedural interface. | MySQLi provides both procedural and object oriented interface. |
MYSQL extension does not support stored procedure. | MySQLi supports store procedure. |
MYSQL does not support prepared statements. | MySQLi supports prepared statements. |
MySQL extension lags in security and other special features,comparatively. | MySQLi extension is with enhanced security and improved debugging. |
Transactions are handled by SQL queries only. | MySQLi supports transactions through API. |
Extension directory: ext/mysql. | Extension directory: ext/mysqli. |
No comments: