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

Help! Copied Table But Lost Autoincrement

forums › forums › SQLyog › Using SQLyog › Help! Copied Table But Lost Autoincrement

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • June 27, 2011 at 6:13 am #32369
      ashwin
      Member

      Hi,

      Quote:
      When I tried to reset it I got a message “Invalid default value for 'ID'” which is my index field

      Auto-increment column must be indexed, and it cannot have a DEFAULT value. Refer http://dev.mysql.com/doc/refman/5.6/en/create-table.html

      If you enable the option “With Indexes” in “Duplicate Table” then the Auto-increment column will be indexed. Please check this option as shown in the attached image.

      Thanks,

      Ashwin A

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.