PHPpgAdmin:如何在不使用SQL的情况下删除行

时间:2022-10-21 22:21:30

In phpMyAdmin I can delete rows without using SQL.

在phpMyAdmin中,我可以在不使用SQL的情况下删除行。

Is there a way to do this in phpPgAdmin ?

有没有办法在phpPgAdmin中执行此操作?

2 个解决方案

#1


4  

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.

phpPgAdmin(ppa)只有在表中(或在查询的请求字段中)找到唯一索引时才能编辑/删除行,并且索引col的值不为null。

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

如果没有唯一索引(或PK),ppa将无法确定WHERE子句以选择您要编辑/删除的唯一行。

#2


2  

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

是的,只需选择表格,单击“浏览”,然后为要删除的每一行单击“删除”(在“操作”列中)。

#1


4  

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.

phpPgAdmin(ppa)只有在表中(或在查询的请求字段中)找到唯一索引时才能编辑/删除行,并且索引col的值不为null。

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

如果没有唯一索引(或PK),ppa将无法确定WHERE子句以选择您要编辑/删除的唯一行。

#2


2  

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

是的,只需选择表格,单击“浏览”,然后为要删除的每一行单击“删除”(在“操作”列中)。