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 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" Link to comment https://forums.phpfreaks.com/topic/18292-sql-increment-syntax/#findComment-80444 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.