*** Question (1)

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 ?

Exemple :

CREATE PROCEDURE Proc_1 ()

BEGIN

SELECT FIELD_X FROM TABLE_Y WHERE FIELD_X = 'X' FOR UPDATE;

... update of TABLE_Y in a cursor FETCH loop ...

CALL Proc_11();

... Proc_11 did not see changes ...

END;

*** Question (3)

Does store procs first statement (BEGIN) have a signification in terms of transactionnal mode ?

Thanks in advance for any help.