Description:
mysql> SHOW CREATE TABLE test;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------+
| test | CREATE TABLE `test` (
`c1` int(11) NOT NULL default '0',
`c2` int(11) default NULL,
PRIMARY KEY (`c1`)
) ENGINE=BLACKHOLE DEFAULT CHARSET=latin2 COLLATE=latin2_croatian_ci |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------+
1 row in set (0.00 sec)
mysql> DELETE FROM test WHERE c1=10;
ERROR 1031 (HY000): Table storage engine for 'test' doesn't have this option
How to repeat:
HELP ME.
