Tag Info

New answers tagged


This can be done with DDL alone but it's not at all trivial. The following will ensure that any test will either have 0 or 5 test cases: create table test ( test_id integer not null, constraint pk_test primary key (test_id) ) ; create table test_case ( test_id integer not null, case_no smallint not null, ...


From here, replace TYPE=MYISAM with ENGINE=MYISAM. This used to be acceptable syntax, but has been deprecated and removed in 5.5 (from the same thread).

Top 50 recent answers are included