Version 4 (modified by 14 years ago) (diff) | ,
---|
test Join query :
Test /gcc/handwritten/java/test/QueryRuleUtilTest.java
- create db xqtlworkbench & run XqtlWorkbenchUpdateDatabase?.java
- create db xqtleuratrans
Run As application "JoinQueryExample?" , works for Use UseCase? that has data . Individual insert data fails :
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`xqtleuratrans`.`individual`, CONSTRAINT `individual_ibfk_1` FOREIGN KEY (`id`) REFERENCES `observationtarget` (`id`) ON DELETE CASCADE)
- Upper case issue in mysql. or Individual id is a foreign key to another table :
- Fix that .
Lifelines presentation and data
Got presentation