Explain the difference between mysql and mysqli

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Explain the difference between mysql and mysqli interfaces in PHP?

mysqli is the object-oriented version of mysql library functions.

(Continued on next question...)

Other Job Interview Questions

• MySQL - What should I do to prepare my client code to use performance-enhancing replication?
• Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
• What are CSV tables?
• How MySQL Locks Tables
• MySQL - User Names and Passwords
• MySQL - User Names and Passwords
• MySQL - MySQL Extensions to ANSI SQL92
• MySQL - Speed of INSERT Queries
• What does + mean in REGEXP?
• When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
• More...