in reply to Re^5: turning off Autocommit (MySql)
in thread turning off Autocommit (MySql)

Its a MyISAM table. I've never dealt with MyISAM or InnoDB, so is this wrong ? If yes, how do I create InnoDB tables ?

Luca

Replies are listed 'Best First'.
Re^7: turning off Autocommit (MySql)
by tirwhan (Abbot) on Nov 11, 2005 at 16:01 UTC

    Try "CREATE TABLE test (str VARCHAR(50)) ENGINE=InnoDB". If that doesn't work it's likely you need to change your mysql configuration and/or initialise the tablespace, check the MySQL docs here for that, it's somewhat out of scope for this forum.


    Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -- Brian W. Kernighan
Re^7: turning off Autocommit (MySql)
by jeanluca (Deacon) on Nov 11, 2005 at 16:00 UTC
    guess this is the solution:CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

    Yep rollback works!!!!!
    Thanks a lot! Luca