Can I directly edit the data from a result of a query?
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for SQLite, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
Yes, Navicat supports to update directly into the result window of a query. However, there's some restriction.
- Only for MySQL, PostgreSQL, SQLite and MariaDB.
- 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 window is not editable.