Jump to content


Photo

SQL Increment syntax?


  • Please log in to reply
1 reply to this topic

#1 tomfmason

tomfmason
  • Staff Alumni
  • Advanced Member
  • 1,696 posts
  • Locationstealing your wifi

Posted 22 August 2006 - 12:48 PM

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

Traveling East in search of instruction, and West to propagate the knowledge I have had gained.

current projects: pokersource

My Blog | My Pastebin | PHP Validation class | Backtrack linux


#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 25 August 2006 - 07:05 PM

MySQL uses "AUTO_INCREMENT" keyword , MSSQL uses "IDENTITY"
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users