*************************** 1. row ***************************
Table: t1
Create Table: CREATE TABLE `t1` (
`ID` int(11) NOT NULL auto_increment,
`Processed` enum('Y','N') NOT NULL...

This may help:

+-----------+---------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |...

This is what I find weird. The way I read the constraint is that the constraint is on it's own table and not on another table. In this case t1.ID

HI there



The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any rows into the table without getting the above error. I did not build this...

Hi there,

Can someone please help me in optimizing a query.

The query that I have is as follows:

CREATE TAbLE RED_WINE_TXN AS
SELECT MEMBER_SEQUENCE, SUM(PURCHASE_VALUE) PURCHASE_VALUE,...

Hi there,
First things first.
String IDNumber
Unless you are expecting non-numeric characters to populate this string you should try and declare the ID as an integer.

e.g. private int...