Mailing List Archive


Back to the month index Back to the list index
Mike Black (mblack@csihq.com)
Tue, 07 Jan 1997 12:01:55 -0500 

Message-Id: <3.0.1.32.19970107120154.0099fc50@mail.csihq.com>
Date: Tue, 07 Jan 1997 12:01:55 -0500
From: Mike Black <mblack@csihq.com>
Subject: [mSQL] Automatic sequence?

I've not found a way yet to implement an automatically incrementing
sequence. I do know of the "CREATE SEQUENCE" but that does not provide a
convenient way to generate SQL that will insert items into a table.

MSQL 1.0 had a patch that did an autoincrement when the PRIMARY KEY field
was NULL. This meant that a single SQL INSERT with a NULL would
auto-select the next available index.

Is there any way to do this in MSQL 2.0 using only SQL (e.g. from the msql
prompt)??

-
 /----------------------------------------------------------\
| Mike Black mblack@csihq.com 407-676-2923, x203 |
| Computer Science Innovations, Inc. 407-676-2355 FAX |
| Melbourne FL 32904-2314 http://www.csihq.com |
 \----------------------------------------------------------/
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!