What is the difference between mysql and mysqli

Please log in or register to like posts.

  • Fundamentally, MySQL is the old database driver, and MySQLi is the Improved driver. The “I” remains for “enhanced” so it is MySQL moved forward. 
  • MySQLi should be possible procedural and questions situated through MySQL must be utilized procedurally. Mysqli additionally bolsters arranged explanations that shield from SQL Injection.
The main useful features are:
  1. an Object-oriented interface
  2. support for prepared statements
  3. support for multiple statements
  4. support for transactions
  5. enhanced debugging capabilities
  6. embedded server support

MySQL is a relational database management system (or RDBMS) –meaning that it is a database management system based on the relational model.

MySQLi Extension (or simply known as MySQL Improved or MySQLi) is a relational database driver that is used mainly in the PHP programming language. It provides an interface to the already founded MySQL databases. It is quite literally an improved version of its predecessor, MySQL, which was simply a means to manage databases over servers.

Reactions

0
0
0
0
0
0
Already reacted for this post.

Reactions

One comment on “What is the difference between mysql and mysqli

Leave a Reply

Your email address will not be published. Required fields are marked *