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

delete a recored without a primary key

forums › forums › SQLyog › Using SQLyog › delete a recored without a primary key

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 30, 2005 at 9:51 pm #8763
      leegold
      Member

      When i try to delete a record mysqljog will not. It says its an illegal action because the table does not have a primary key field.

      Please tell me how to over ride this. Ie. please tell me how to delete records in a table with no PK?

      The checkbox IS specific for a record therefore I should be able to do this with via the GUI and not having to resort to SQL code. Thanks.

    • January 31, 2005 at 5:57 am #16916
      Ritesh
      Member

      Currently to edit/insert/delete any record in the Insert/Update window, you require to have a PK defined on the table.

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