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

How To Update Column Values ?

forums › forums › SQLyog › Using SQLyog › How To Update Column Values ?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • April 8, 2013 at 4:55 am #34289
      Jan.S
      Member

      If there are many tables with a column of the same name, then if we do not explicitly choose a table, any modifications made could be ambiguous.

      For example, If there is a table with columns actor_id and actor, and another table with film_name and actor_id, a stored procedure with join on both tables will result in a column actor_id. While updating the column, it could pertain to either the film table or the actor table.

      Therefore, the only way to edit a result where multiple tables are involved is by selecting a specific table from the drop down and editing the values in that table.

    • April 10, 2013 at 2:21 pm #34290
      sanko
      Member
      'Jan.S' wrote:

      Therefore, the only way to edit a result where multiple tables are involved is by selecting a specific table from the drop down and editing the values in that table.

      This does not enable edit . what is the procedure to enable edit ?

    • April 12, 2013 at 5:37 am #34291
      sathish
      Member

      Hello,

      Click on the drop down in the result tab which will have the tables. Please find the screenshot attached.

      Regards,

      Sathish

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