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

"Read Only" Tables

forums › forums › SQLyog › Using SQLyog › "Read Only" Tables

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 28, 2003 at 1:38 am #8284
      commsys
      Member

      Some, but by no means all, tables within a particular DB come up as “read Only” and I cannot insert new records, edit existing records, or alter the table.

      I am signing in as the main Admin user and in checking the User, Host, DB Tables in MySQL DB, I see no reason that I shouldn't have enough privileges to do any/all of these things.

      With the except of this single issue, I just love SQLyog so far.

      Thanks.

      john at whisperingwaters dot com

    • December 29, 2003 at 9:10 pm #15376
      CalEvans
      Member

      Not sure if it will help but the only time this happens to me is when I'm trying to edit a recordset and not a table. Does it happen to you if you click on the table name on the tree control on the left and then press CTRL+ENTER? Is it a derived table?

      HTH,

      =C=

    • January 3, 2004 at 12:46 pm #15377
      Shadow
      Member

      Even if you open a table you may not be able to edit it provided that the given table has no primary key. Constructing corresponding SQL statements manually will do the job, though.

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