File
Description
columns_priv.MYD
columns_priv.MYI
Permission for individual columns within a table
columns_priv.frm
host.MYD
host.MYI
General permission by host
host.frm
tables.MYD
tables.MYI
Permission for individual tables within a database
tables.frm
user.MYD
user.MYI
General Permission by user
user.frm
MySQL table types
MySQL supports two different types of table:
Not transaction safe tables which are:
  ISAM
  MyISAM
  HEAP
  MERGE
Transaction safe tables which are:
  InnoDB
  BDB
Database systems that support simultaneous users must ensure that changes to 
the database cannot corrupt the database or leave it in an inconsistent state. 
Most RDBMS can bundle multiple updates (adds, changes, or deletes) together 
into transactions; see Example 1 1. Transactions have four important features 
usually referred to as the ACID properties: 
Atomic:
Transactions either completely succeed or completely fail. If the system 
crashes before the transaction completes the database's state does not 
change. 
34 
MySQL to DB2 UDB Conversion Guide






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved