hi,

I would like to know how to write in SQL if my table need a auto runing number for each record? let say

auto ID item code qty
1 A100 10
2 A101 5
3 A102 13


how to write in SQL language to get a auto running number on my table?


thanks

What is your database platform? There are certain ways that make this completely automatically and less prone to problems if you have a db platform that supports it (MS Access, MS-SQL Server).

Here is one way you could do this:

INSERT INTO myTable(autoIDColumn,...) VALUES(
    (SELECT MAX(autoIDColumn)+1 FROM myTable)
    , ...)

Peter
------------------------------------------------------
Work smarter, not harder.