Hello,
I am installing mysql on winxp home.
In mysqlcc select works fine. but select count (*) from table result in a error in sintax.

Rollback does not work.
What is the innodb ?

Any idea what is wrong.
Regards

It looks like you have a space after count.
The statement should instead read:
SELECT COUNT(*) FROM table;

InnoDB tables support transactions. Unless you specifically
specified that the table type should be InnoDB in your
'CREATE TABLE' statement, chances are you don't have a
table that supports transactions.

Once you've created your InnoDB tables, transaction syntax
is the following:
http://www.mysql.com/documentation/m...ce.html#COMMIT