Can I directly edit the data from a result of a query?

Apply OS: Windows, Mac, 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 MarisDB.

- 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.

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


Article is closed for comments.