kickassamd Posted October 26, 2005 Share Posted October 26, 2005 I have a column that is only numbers (starts at 0) that i would like to auto increase by 1 on each access... example select * from `users` where `username` = 'bob' and `password` = 'bobspass'; i would like to have the record of bobs accessID increase by 1 then the next time he \ she logs in add 1 again... etc etc etc Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted October 26, 2005 Share Posted October 26, 2005 you cannot do it while selecting... need a separate query to update. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.