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|
write a command to view the content of the table
What you can use regular expression for in mysql? Support your answer with an example?
What is 'mysqlshow'?
What is sqlyog?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
What is 'mysqld'?
What is the latest version of php and mysql?
How would you get the current date in mysql?
How do you start MySQL on Linux?
What is maximum size of a database in MySQL?
How many ways we can we find the current date using MySQL?
In which year mysql created?