Glossary Item Box

DBACentral for MySQL Submit feedback on this topic   

Edit Table Dialog

The Edit Column dialog allows you to edit the properties of the database table before the database is created. This dialog is accessible from the Import Database Wizard.

 

 

The main area of the dialog allows you to modify the following table properties:

  • Table Name - the name of the table, which must be unique within the database.
  • Table Type - MySQL-specific type of the designed table. This type defines how MySQL stores and searches data in tables. Note, that to use MySQL foreign keys (diagram references) you should use the InnoDB table type.
  • Row Format - defines how rows will be stored in the MySQL table.
  • Comment - A 60-character native MySQL comment for your table.

     

    The properties pane allows you to define the advanced properties of the column. These properties are:

  • Min. Rows - defines minimum number of rows you plan to store in the table. Leave zero for the default value.
  • Max. Rows - defines maximum number of rows you plan to store in the table. Leave zero for the default value.
  • Avg. Row Length - an approximation of the average row length for your table. You only need to set this for large tables with variable size records.
  • Auto Increment - the next AUTO_INCREMENT value you want to set for your table (MyISAM only).
  • Pack Keys - this option works for MyISAM and ISAM tables only. It makes table indexes smaller. This usually makes updates slower and reads faster.
  • Checksum - this option works for MyISAM tables only. It maintains a checksum for all rows (makes table a little slower to update but makes it easier to find the corrupted tables).
  • Delay Key Write - this option works for MyISAM tables only. It delays key table updates until the table is closed.
  •  

     


    ©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.