Foreign keys in InnoDB tables

2002-10-21 Thread Christos Stigas
Hello I am a brand new user of MySql, and have some questions about using InnoDB tables. I noticed in the manual that you can only specify - ON DELETE SET NULL Or - ON DELETE CASCADE What is the default behaviour if nothing is specified? Also, does anyone know if there are any plans to s

Foreign keys in InnoDB tables

2002-10-20 Thread Christos Stigas
Hello I am a brand new user of MySql, and have some questions about using InnoDB tables. I noticed in the manual that you can only specify - ON DELETE SET NULL Or - ON DELETE CASCADE What is the default behaviour if nothing is specified? Also, does anyone know if there are any plans to su