Results 1 to 2 of 2

Thread: Catch an auto-increment ID

  1. #1
    Join Date
    Apr 2006
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Catch an auto-increment ID

    Hello!!

    How can I catch an auto-increment ID in a table with a SQL querie?

    For example:

    ...ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

    and I wan´t select the 20. How can I do this??

  2. #2
    Join Date
    Apr 2006
    Posts
    429
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    SELECT id FROM tablename WHERE ID = 20; i think

    [edit]

    can't quite understand what u want to happen
    Last edited by jr_yeo; 07-18-2006 at 03:39 PM.
    Please don't mind me. I am just posting a lot of nonsense.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •