http://www.databasejournal.com/features ... hp/3382171
I typed in the following example:
Code: Select all
Let's try looking from a different connection. For this exercise, open two connections to the database.
Connection 1:
mysql> CREATE TABLE t (f INT) TYPE=InnoDB;
mysql> BEGIN;
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO t (f) VALUES (1);
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM t;
+------+
| f |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
Connection 2:
mysql> SELECT * FROM t;
Empty set (0.02 sec)
The important point is that running the same query from different connections (one within the middle of a transaction, the other from without) produces different results. Now, commit the transaction from the first connection, and run the query again from connection 2.[edit] Do I need to install something extra to make InnoDB work? [/edit]