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

Error 1062

forums forums SQLyog Using SQLyog Error 1062

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • #14931
      CalEvans
      Member
    • #14932

      I deleted the row, and changed the table type to MyISAM and it didn't work.

      Can you explain the Delete From, How do I do that?

      Table Name =users

      Column = “id”

      Row= with problem= id = 2147483647, when it should be about 369

    • #14933
      Shadow
      Member

      Issue an INSERT INTO command that explicitly sets the id column to the next desired value. That will reset the counter.

    • #14934
      Shadow
      Member

      My bad, I replied before thinking! An INSERT INTO works only if you specify a higher value than the current seed. If you use MyISAM then you should take advantage of the -A option of myisamchk:

      Quote:
      -A or –set-auto-increment[=value]

      Force AUTO_INCREMENT to start at this or higher value. If no value is given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1.

    • #14935

      Shadow

      what do I actually type to set to a value I keep getting

      and then do I hit “execute query”

      This is the error code I get when I hit “execute query”

      Error Code : 1064

      You have an error in your SQL syntax near 'auto-increment[=372] ' at line 1

      (350 ms taken)

      Thanks

    • #14936

      What if I unchecked the auto-increment, and then assigned the id number myself?

    • #14937

      Its fixed: these are the steps I took:

      1. Clicked on the Table

      2. went to “Alter Table Structure”

      3. went to “Other Properties”

      4. then inserted the next number in “Autoincremet box”

      Thanks

Viewing 6 reply threads
  • You must be logged in to reply to this topic.