Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Create a Table for Transaction Testing
How To Create a Table for Transaction Testing? - MySQL FAQs - Transaction Management: Commit or Rollback
✍: FYIcenter.com
If you want to learn transaction management, you should create a table with the InnoDB storage engine. The default storage engine MyISAM does not support the transaction concept. The tutorial exercise below shows you a good example of creating a new table with the InnoDB storage engine:
>\mysql\bin\mysql -u dev -piyf fyi mysql> DROP TABLE fyi_links; mysql> CREATE TABLE fyi_links (id INTEGER PRIMARY KEY, url VARCHAR(16) NOT NULL, notes VARCHAR(16), counts INTEGER, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP()) ENGINE = InnoDB; Query OK, 0 rows affected (0.25 sec) mysql> SHOW CREATE TABLE fyi_links; CREATE TABLE `fyi_links` ( `id` int(11) NOT NULL, `url` varchar(16) NOT NULL, `notes` varchar(16) default NULL, `counts` int(11) default NULL, `created` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.05 sec)
You should keep this table for to practice other tutorial exercises presented in this collection.
2007-05-11, 5124👍, 0💬
Popular Posts:
How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics If you want conc...
What are the high-level thread states? The high-level thread states are ready, running, waiting, and...
Can you write a program to interchange 2 variables without using the third one? a = 7; b = 2; a = a ...
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
How To Test Transaction Isolation Levels? - MySQL FAQs - Transaction Management: Commit or Rollback ...