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 BDB Storage Engine
How To Create a New Table Using the BDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has been used in products from many companies, like Cisco Systems.
BDB is not the default storage engine. You need to specify "ENGINE = BDB" at the end of the "CREATE TABLE" statement to create new tables with the BDB storage engine. The tutorial exercise below shows you a good example:
>cd \mysql\bin >mysql -u dev -piyf fyi mysql> CREATE TABLE fyi_bdb ( id INTEGER PRIMARY KEY, title VARCHAR(80), count INTEGER ) ENGINE = BDB; Query OK, 0 rows affected, 1 warning (0.07 sec) mysql> SHOW CREATE TABLE fyi_bdb; CREATE TABLE `fyi_bdb` ( `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) mysql> drop table fyi_bdb; Query OK, 0 rows affected (0.00 sec)
The "SHOW CREATE TABLE" command reports that table "fyi_bdb" was actually created with the MyISAM storage engine. This is because the BDB storage engine is not included in the default "mysqld" configuration.
2007-05-10, 4562👍, 0💬
Popular Posts:
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
How To Get the Minimum or Maximum Value of an Array? - PHP Script Tips - PHP Built-in Functions for ...
How To Fade Image Edges to Background Colors? - PSP Tutorials - Fading Images to Background Colors w...
What are unadjusted function points and how is it calculated? Unadjusted function points = ILF + EIF...
How can I show HTML examples without them being interpreted as part of my document? Within the HTML ...