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.

Have more questions? Submit Ticket.
Have more questions? Submit a request


Article is closed for comments.