a little and simple problem about sql statement...

[una_noche]

hello i'm newbie here and have a simple problem.
could anyone here tell me how to write a sql statement in my JSP coding about an auto-increment process. i already search through the internet but can't find any suitable example. hope anyone in here can help me.
~really need help...
~thanks...

[bubbisthedog]

MySQL, when creating the table:
http://www.netadmintools.com/art387.html

SQL Server, when creating the table:
http://msdn2.microsoft.com/en-us/library/aa933196(SQL.80).aspx

[mattyblah]

auto-incrementing can be done either by the db or manually. if you're looking for the db implementation, see the above poster. if you're looking for manual implementation, good luck. i'm sure you won't find much out there that is "recommended".