Trigger by Ctrl-clicking a cell or right-clicking a cell and selecting Edit.

Multiple modifications can be made to the same result set, then submitted or undone in one go.

SQL

Only supports modifying results of simple single-table queries, and the results must include all primary key columns.

Only non-primary key columns can be edited.

You can also select the Raw SQL mode and enter raw expressions. DBNova uses them to splice SQL. In projects marked as production environments, a secondary confirmation pop-up will appear.

MongoDB

Only supports modifying results of the find command, and the results must include _id.

The input content is JavaScript, and users can return any value.

If the return value is undefined, the field will be unset.

Redis

Supported commands for modification: get、hget、hgetall、hmget 、hscan 、lindex 、lrange 、zrange 、zrangebyscore 、zscan.

The input content is JavaScript, and users can return any value (Objects will be serialized to JSON).

If the return value is undefined, the field will be deleted (except for list-related commands).