RE: sql question:
- From: "Rodney Haynie" <RHaynie@xxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Wed, 12 Mar 2008 22:10:49 -0400
Sure there is. In your create table statement, you would define your table
with an auto increment field. Some programs call it identity.
An example MySQL syntax is:
CREATE TABLE Client (
ClientID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
...
What are you using? SQL Server, Oracle, MySQL, ...?
Good luck.
Rodney
_____
From: programmingblind-bounce@xxxxxxxxxxxxx
[mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Charles E. Black
Sent: Wednesday, March 12, 2008 6:31 PM
To: programmingblind@xxxxxxxxxxxxx
Subject: sql question:
Is there a method to get sql to have an autonumber field. I am inserting
rows of a table in a webpage. I need to either get the Record
identification field to advance each time I put in a message or I will have
to retrieve the last message and then add 1 to it. I would prefer not to
have to do it the second way because it may cause complications. Can
someone advise!
Charles Black
4127 Pinehaven Ct.
Columbia, SC 29205
Phone: (803) 790-5586
Cell: (803) 873-1698
Other related posts:
