Tag Info

New answers tagged

2

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, ...


3

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