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, 1573🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...