CREATE TABLE users (
user_id int(10) unsigned NOT NULL auto_increment,
username varchar(20) NOT NULL default '',
password varchar(20) NOT NULL default '',
PRIMARY KEY (user_id)
) TYPE=MyISAM;Questions:
1. What is the purpose of MyISAM?
2. What happen if I created the above table without MyISAM.
Well, If you don't specify the storage engine type, the default is MyISAM. There are different storage engine types.
Here is the detailed description of the storage engines. http://dev.mysql.com/tech-resources/articles/storage-engine/part_1.html
Cheers,
Naveen
Thanks Naveen.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.