Re: How to create a rollback? (test source valid)

[Fredrik Andersson]

/*
Hello!
The error was the type of DB. At first I did not used InnoDB but after I have created a my.cnf file and restarted the MySQl database with --defaults-extra-file=C:/mysql/data/my.cnf
I could create my tables like:

CREATE TABLE test1
(
id INT NOT NULL AUTO_INCREMENT,
date DATETIME NOT NULL,
PRIMARY KEY(id)
)
TYPE = INNODB;

CREATE TABLE test2
(
id INT NOT NULL AUTO_INCREMENT,
test1_id INT NOT NULL,
PRIMARY KEY(id)
)
TYPE = INNODB;

After that everything worked fine if I got a exception and needed to do a rollback.

Best regards
Fredrik

*/