Question

Advantages of using MySQLi over MySQL?

Answer 1

MySQLi has many advantages over MySQL. Some of these are given as follows −

MySQLi supports both procedural interfaces and object oriented interfaces while MySQL supports only procedural interfaces.

MySQLi supports stored procedure but MySQL does not.

There is enhanced security and improved debugging features in MySQLi where this is comparatively lagging in MySQL.

MySQLi supports prepared statements but MySQL does not.

Transactions are supported through API in MySQLi but they ae handled hrough queries only in SQL.