Collections:
Tables Using InnoDB Storage Engine in MySQL
How To Create a New Table Using the InnoDB Storage Engine in MySQL?
✍: FYIcenter.com
InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org.
InnoDB is not the default storage engine. You need to specify "ENGINE = InnoDB" at the end of the "CREATE TABLE" statement to create new tables with InnoDB storage engine. The tutorial exercise below shows you a good example:
>cd \mysql\bin >mysql -u dev -piyf fyi mysql> CREATE TABLE fyi_inno ( id INTEGER PRIMARY KEY, title VARCHAR(80), count INTEGER ) ENGINE = InnoDB; Query OK, 0 rows affected (0.17 sec) mysql> SHOW CREATE TABLE fyi_inno; CREATE TABLE `fyi_inno` ( `id` int(11) NOT NULL, `title` varchar(80) default NULL, `count` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.02 sec) mysql> INSERT INTO fyi_inno (id) VALUES(-1); Query OK, 1 row affected (0.05 sec)
⇒ Data File for InnoDB Storage Engine in MySQL
⇐ Repair MyISAM Tables in MySQL
2017-09-01, 2017🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...