Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2172
  • Last Modified:

What's the difference between MySQL, MySQLi and MySQLt, and how to change between them?

I would like to know what the difference between mysql, mysqli and mysqlt is.

I would also like to know how to change between the standard mysql installation on ubuntu server, and mysqlt.

I have a web application that needs to use "mysqlt", but can't seem to find an answer on google for this.
0
pyrotherm
Asked:
pyrotherm
1 Solution
 
PriceDCommented:
0
 
haijeromeCommented:
Hi,
 
   Most obviously Google won't reply you with what you need. Because you thought that mysqlT is a different extension / library like mysqli / PDO but really its not.. I explained it after the differences between three of them.

     The differences are little but it matters more in real time.  

  1.    The old MySQL extension misses some really important features like prepared statements and native transaction support.
  2.   MySqli is more OOP orientated.Whereas MySQL is not so.
  3. Mysqli realy helps to prevent SQL injection.
   And regarding Mysqlt
   
     The mysqlt stands for Mysql Transactions. The transaction support is built into the module by default.

    Kindly go thru the below links

   1. http://www.tutorialspoint.com/mysql/mysql-transactions.htm
   2. http://www.mysql.com/news-and-events/generate-article.php?id=2002_11

 
So You can not use transactions directly, you can but they would not be  save and guaranteed. If you plan to use transactions in your MySQL  programming then you need to create your tables in a special way. There  are many type of tables which support transactions but most popular one  is InnoDB.

I think it helps you..If so then its cool else let me know...

Regards,
Jerome Dennis D
   
     
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now