Collections:
Tables Using MyISAM Storage Engine in MySQL
How To Create a New Table Using MyISAM Storage Engine in MySQL?
✍: FYIcenter.com
MyISAM storage engine is based on the ISAM (Indexed Sequential Access Method) concept, which was first developed at IBM to store and retrieve data on secondary storage systems like tapes. MyISAM storage engine offers fast data storage and retrieval. But it is not transaction safe.
MyISAM is the default storage engine. All new tables will be created with MyISAM storage engine if you do not specify any storage engine name. But if you want to create a new table with MyISAM storage engine explicitly, you can specify "ENGINE = MYISAM" as the end of the "CREATE TABLE" statement. The tutorial exercise below shows you a good example:
>cd \mysql\bin >mysql -u dev -piyf mysql> USE fyi; mysql> CREATE TABLE fyi_isam ( id INTEGER PRIMARY KEY, title VARCHAR(80), count INTEGER ) ENGINE = MYISAM; Query OK, 0 rows affected (0.08 sec) mysql> SHOW CREATE TABLE fyi_isam; CREATE TABLE `fyi_isam` ( `id` int(11) NOT NULL, `title` varchar(80) default NULL, `count` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.02 sec)
⇒ Data File for MyISAM Storage Engine in MySQL
⇐ Major Storage Engines Supported in MySQL in MySQL
2017-09-12, 3401🔥, 0💬
Popular Posts:
How To Concatenate Two Character Strings Together in SQL Server Transact-SQL? Concatenating two char...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...