Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
incrementing a column without having to query the db first
I'm fairly new to mysql. I have a table with 1 unique/primary column and another called user_id that is unique but doesn't auto increment. When I add someone to the database, I don't know how to increment user_id without querying the db and find the last value first.
