MySQL provides CREATE TABLE statement to create tables into a database. CREATE TABLE statement has several options to set for the table. While creating a table we can use ENGINE or TYPE option to ask MySQL to create a table of any type available on the server. ENGINE or TYPE option works same, you can use any of them passing 'MYISAM' value. Take following two examples:
CREATE TABLE buyers
( buyer_id INT UNSIGNED NOT NULL,
first_name CHAR(19) NOT NULL,
last_name CHAR(19) NOT NULL,
age SMALLINT NOT NULL,
post_code SMALLINT NOT NULL
) ENGINE=MYISAM;
or
CREATE TABLE buyers( buyer_id INT UNSIGNED NOT NULL,
first_name CHAR(19) NOT NULL,
last_name CHAR(19) NOT NULL,
age SMALLINT NOT NULL,
post_code SMALLINT NOT NULL
) TYPE=MYISAM;