Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Unanswered: select count (*) from table

    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

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •