Software QA (13)
SQL Server (1)
How To Create a New Table Using the InnoDB Storage Engine
How To Create a New Table Using the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
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)
2007-05-10, 4730👍, 0💬
How To Enter Microseconds in SQL Statements? - MySQL FAQs - Introduction to SQL Date and Time Handli...
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...