Insert into Table and get auto_increment id

  • Maniac

    Maniac - 2004-04-09


    Inserting values works fine, except that i want to get the auto_increment value of the inserted line. in mssql its @@identity. how can i get the id of the new entry?


    • Anonymous - 2004-04-19

      I am having the same issue.  I thought it might be a case of setting the parameter direction to output.  But I think that the implementation is input only.  Help

    • eric677

      eric677 - 2004-04-22

      Can use this sql statment:
      select LAST_INSERT_ID()

      • Maniac

        Maniac - 2004-04-22

        thank you eric677


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks