I had some troubles with transactions while using the MySQLCommunityServer plugin.
For MySQL I have to use “START TRANSACTION” instead of “BEGIN TRANSACTION” (SqlLite) and I saw my remote table-engine was MyIsam by default, while I wanted to use InnoDB in order to have transactions working.
Shouldn’t it be a good practice to have create table queries like this: ?
sql = "CREATE TABLE Team2 (ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, Name TEXT, Coach TEXT, City TEXT) [b]ENGINE=INNODB[/b];
Just a question.