|
|
|
|
| |
Creating, Dropping, Indexing, and Altering Tables
MySQL allows you to create tables, drop (remove) them, and change their structure using the CREATE TABLE, DROP TABLE, and ALTER TABLE statements. The CREATE INDEX and DROP INDEX statements allow you to add or remove indexes on existing tables. But before diving into the details for these statements, it's helpful to understand something about the different types of tables that MySQL supports.
Table Types
MySQL supports multiple table handlers, each of which implements a table type that has a specific set of properties or characteristics. The table types actually available to you will depend on your version of MySQL, how it was configured at build time, and the options with which it was started. The current table type handlers and the versions in which they are first available are listed in the following table
| Table Type |
MySQL Version First Available |
| ISAM |
All versions |
| MyISAM |
3.23.0 |
| MERGE |
3.23.25 |
| HEAP |
3.23.0 |
| BDB |
3.23.17/3.23.34a |
| InnoDB |
3.23.29/3.23.34a |
|
|
|
|
|
|
| Link Partners: Asia florist, Flowers to India, Hong kong flowers, Site submit, Cheap web hosting, China florist, Japan florist |
|
