Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Back To 1

forums › forums › SQLyog › Using SQLyog › Back To 1

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 29, 2006 at 12:37 pm #10111
      Obi1
      Member

      I'am using sqlyog just a few days now, and i'am working with php an ADOdb.

      The problem is, when i have a column in a table and it is an integer with autoincrement if i have for example 8 rows and i delete the last one when i post a new one instead of being 8 again it's 9 so it jumps from 7 to 9. how can i emend this?

    • December 29, 2006 at 2:54 pm #23179
      peterlaursen
      Participant

      You are not supposed to amend this! 'Autoincrement' means 'give me a unique number and I do not care what it is'.

      This is the server behaviour ….

      However you can with SQLyog right-click a table .. ALTER TABLE .. advanced properties .. and enter the new autoincrement 'offset' before entering data.  Use version 5.22 RC3 for this (some bugs were fixed in the 5.22 tree with ALTER TABLE ..advanced properties).

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.