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

AutoIncrement Column

forums › forums › SQLyog › Using SQLyog › AutoIncrement Column

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 12, 2005 at 7:56 am #8971
      bluelotus
      Member

      Hi

      Can anyone tell me how to create an automincrement column in a MySQL table, through SQLYog ?

      Thanks

      Manish

    • May 12, 2005 at 8:01 am #17771
      Ritesh
      Member

      In the Create/Alter Table… window there is an Auto Incr? column.

      Check it for the corresponding column that you want to make Auto Increment.

    • May 12, 2005 at 8:44 am #17772
      bluelotus
      Member

      Ritesh

      Thanks. Got it.

      I also want the SQL syntax for adding an autoincrement column to an existing table.

      and also how to delete the autoincrement column in a table through sql query.

      I want the syntax.

      Thanks

      Manish

    • May 12, 2005 at 9:07 am #17773
      Ritesh
      Member

      http://dev.mysql.com/doc/mysql/en/example-…-increment.html

      Its all there in the MySQL documentation and SQLyog's History Pane.

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