On Jun 22, 3:25 am, earthwormgaz <earthworm(dot)(dot)(dot)(at)googlemail(dot)com> wrote:
> hello, i'm trying to do a simple (so i thought) sql insert operation,
> but i'm being told the insert violates unique constraint
> say i've got three columns, two text and one integer for the id, i'm
> doing the following
> INSERT INTO myTable (text1, text2) VALUES ('some text', 'some more
> text');
> so i'm not trying to enter anything into the key column, i thought a
> unique one should be generated for me?
DDL please...