Can I directly edit the data from a result of a query?
Apply OS: iOS
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL
Apply Navicat Version No.: All
Yes, Navicat supports to update directly into the result of a query. However, there's some restriction.
- The table must have primary keys and the sql must select all primary keys.
- The query statement needs to include one table only. If it's a join query for two tables, the result is not editable.