MySQL vs MySQLIi

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.