tomfmason Posted August 22, 2006 Share Posted August 22, 2006 Ok I am attempting to create a table in Microsaft Access and am running into a few problems. I have a field that I want to be an auto_increment number. Can I specify the Sequence in the query that creates the table or do I have to Have a different query that would make the desired field an incremented number?Any suggestions would be great.Thanks,Tom Quote Link to comment https://forums.phpfreaks.com/topic/18292-sql-increment-syntax/ Share on other sites More sharing options...
Barand Posted August 25, 2006 Share Posted August 25, 2006 MySQL uses "AUTO_INCREMENT" keyword , MSSQL uses "IDENTITY" Quote Link to comment https://forums.phpfreaks.com/topic/18292-sql-increment-syntax/#findComment-80444 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.