Explain the difference between mysql and mysqli interfaces
Answers were Sorted based on User's Feedback
Answer / guest
mysqli is the object-oriented version of mysql library
|Is This Answer Correct ?||96 Yes||18 No|
Answer / thaha
Mysql and Mysqli(Mysql Improved) are two library functions
( or Extension) in the PHP which is used to acces mysql
database.Mysqli is the improved version of mysql which
support OOPS. The mysqli extension allows you to access the
functionality provided by MySQL 4.1 and above.
|Is This Answer Correct ?||85 Yes||8 No|
Answer / mohtashim
Mysqli is nothing but an improved version Mysql which
|Is This Answer Correct ?||77 Yes||16 No|
Answer / guruprasad k.m
mysqli is the improved version of mysql and it is mainly
used for object oriented and stored procedure applications
|Is This Answer Correct ?||27 Yes||3 No|
Answer / sakuki
Besides being OO , mysqli allows access to new features
added to Mysql 5.0 > .
For example for using "transactions" and to execute stored
procedures from php we need mysqli. The list is lengthy .
|Is This Answer Correct ?||31 Yes||9 No|
Answer / ravi soam
mysqli is advance compare to mysql, it support to OOPS concept, through mysqli we can access mysql library, while using mysql we can not access all features in mysqli.
|Is This Answer Correct ?||13 Yes||2 No|
Answer / baskaran p
mysqli ia an improved query command
|Is This Answer Correct ?||10 Yes||16 No|
Answer / sunil
mysqli is handling incaptulation.
|Is This Answer Correct ?||8 Yes||15 No|
Answer / baskaran p
Some advance features in mysqli command
|Is This Answer Correct ?||3 Yes||24 No|
Answer / vijay
it is nothing it is making april fool....forget.yar.
|Is This Answer Correct ?||8 Yes||64 No|
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
what is a cursor? : Mysql dba
Why do we use the mysql database server?
What is the use of mysqli_num_rows?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How to delete an existing column in a table?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
How to calculate the difference between two time values?
What is mysql enterprise edition?
What is the innodb in mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
How do you kill a long running query in mysql?