MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 

How to create myisam table in MySQL?

Can you help me to explain, how to create MyISAM table in MySQL?

Answer No: 167

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;

Related MySQL FAQs to the Above FAQ

What-are-MyISAM-table-characteristics What are MyISAM table characteristics?

What-are-MyISAM-formats-in-MySQL What are MyISAM formats in MySQL?

How-MySQL-myisam-table-is-stored-on-disk How MySQL myisam table is stored on disk?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.