No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any … |
|
Hi there, Can someone please help me in optimizing a query. The query that I have is as follows: [CODE]CREATE TAbLE RED_WINE_TXN AS SELECT MEMBER_SEQUENCE, SUM(PURCHASE_VALUE) PURCHASE_VALUE, SUM(QUANTITY) QTY FROM PURCHASE_DETAILS a, RED_WINE_SKUS b WHERE a.PRODUCT_NO=b.PRODUCT_NO AND TRANSACTION_DATE>=20071101 GROUP BY MEMBER_SEQUENCE[/CODE] MEMBER_SEQUENCE: DECIMAL (INDEX) PURCHASE_VALUE: DECIMAL QUANTITY: DECIMAL PRODUCT_NO: DECIMAL … |
|
Re:
Basically is this my test file for some reason is just giving me problems and so I'm currently in the moment trying to correct the problem. I'm also trying to beat a deadline tonight that would give me 20% EC on this assignment. What I need is for someone to … |