Nathan Cook wrote:
> I have a table called course_enrollments with these fields:
> ID,USER_ID,COURSE_ID,LAST_PAGE_ID,STUDENT_STATUS,TYPE,START_DATE,END_DATE, and I
> would like to make the ID field auto increment. I have tried multiple methods
> based on some mysql stuff that I know and some information that I was able to
> get off of this page:
> http://instantdb.enhydra.org/software/documentation/idb3_26/syntax.html
>
> Nonetheless when I insert null values into the db they remain null, instead of
> auto incrementing.
Here is where I found the documentation on how to auto-increment and it worked fine
for me, although I have decided to stop using InstantDB for the time being...
http://instantdb.enhydra.org/software/documentation/idb3_26/types.html
Here is an example:
e.g. CREATE TABLE table1 (int1 int AUTO INCREMENT)
-> richard
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|