Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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)
2007-05-10, 4786👍, 0💬
Popular Posts:
How To Enter a New Row into a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Dev...
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
WHat will be the result of the following code? #define TRUE 0 // some code while (TRUE) { // some co...
How can you implement MVC pattern in ASP.NET? The main purpose using MVC pattern is to decouple the ...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...