PHPpgAdmin: How delete rows without using SQL

2019-07-19 19:09发布

In phpMyAdmin I can delete rows without using SQL.

Is there a way to do this in phpPgAdmin ?

2条回答
Root(大扎)
2楼-- · 2019-07-19 19:43

Yes there is, just select the table, click "browse" and then click "delete" (in the column "actions") for every row you want to delete.

查看更多
可以哭但决不认输i
3楼-- · 2019-07-19 19:44

phpPgAdmin (ppa) gives ability to edit/delete a row only when it founds an unique index in the table (or in requested fields for a query) and the value for the indexed col is not null.

Without unique index (or PK), ppa could not determine a WHERE clause to select the only row you want to edit/drop.

查看更多
登录 后发表回答