Is there anay way to specify in my.cnf or my.ini that all tables that will be created will be InnoDB tables ; instead of specifying Type=InnoDB at each end of CREATE TABLE statement ?
*** Question (2)
I have a stored proc Proc_11 called in a stored proc Proc_1. In Proc_1 a table is locked by SELECT ... FOR UPDATE and changed before calling Proc_11. But, it seems Proc_11's thread does not see changes done by Proc_1. It seems Proc_11's thread is considered as a new independent transaction ?
CREATE PROCEDURE Proc_1 ()
SELECT FIELD_X FROM TABLE_Y WHERE FIELD_X = 'X' FOR UPDATE;
... update of TABLE_Y in a cursor FETCH loop ...
... Proc_11 did not see changes ...
*** Question (3)
Does store procs first statement (BEGIN) have a signification in terms of transactionnal mode ?