A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
EJB 3 in Action
this week in the
EJB and other Java EE Technologies
What does IDENTITY mean in SQL?
Joined: Mar 10, 2004
Mar 03, 2006 02:32:00
CREATE TABLE DEMO_BLOB (
IDCOL INTEGER IDENTITY (1,1) PRIMARY KEY,
In the above SQL command what does that IDENTITY (1,1) mean?
Thank you very much.
Joined: Mar 02, 2006
Mar 03, 2006 02:55:00
it seems to be a "new SQL Standard" way of saying AUTO_INCREMENT in
MySQL or creating a sequence in Oracle.
See the following:
Joined: Jul 08, 2004
Mar 03, 2006 09:43:00
It look to be an identity column which start from 1 and increment by 1
Software Engineer -
I agree. Here's the link:
subject: What does IDENTITY mean in SQL?
Session Bean Identity
Run-as security identity functionality
Seating arrangement application in JSP/Struts
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014