Hello,
Is there possibility to insert NEGATIVE numbers (less than zero) into the
column of SERIAL datatype?
For example:
------------
I have table:
create table TEST
(
ID SERIAL,
NAME VARCHAR(100) NOT NULL,
CONSTRAINT TEST_PK PRIMARY KEY (ID)
)
and I would like to insert column ID = -1, NAME = 'name1'
insert into TEST (ID, NAME) values (-1, 'name1')
but I receive error:
---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;300 POS(1) Integrity violation
insert into TEST (ID, NAME) values (-1, 'name1')
------------------------------------------
How can I use column to be auto incremented and also I can insert NEGATIVE
INTEGER values into this column by myself? Positive numbers is possible insert
without problems.
Thanks for answer,
best regards,
Julian Legeny
mailto:[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
