Mayuran Yogarajah wrote:
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The index file has an `.MYI' (MYIndex) extension.
My question is, why does MySQL create a .frm (table definition) for a
table if that table is of type InnoDB. For example, consider the following:
use test; CREATE TABLE mytest ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL ) TYPE=InnoDB;
This created inside the 'test' directory: mytest.frm
Can anyone provide a reason for this.
To share code. Show create table, etc.
thanks, Mayuran
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
