php phpmyadmin 不能删除一条记录
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17270418/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpmyadmin can't delete one record
提问by Jay
I can't delete one record on PHPMyadmin, I currently have 2 rows in there. I don't want to try deleting the other one but I have been able to delete rows there manually on PHPMyadmin but today it was a different story. I am new at this.
我无法在 PHPMyadmin 上删除一条记录，我目前在那里有 2 行。我不想尝试删除另一个，但我已经能够在 PHPMyadmin 上手动删除那里的行，但今天却是另一回事。我是新手。
回答by sectus
You have no primary key for this table.
您没有此表的主键。
回答by 502_Geek
You can delete via query like that.
您可以通过这样的查询删除。
DELETE FROM yourtable where id = 'deletereocrdid';
回答by Prem Baranwal
It would be deleting but may be the page was not getting refreshed completely and you would have been seeing the data there. But, if still it is not deleting then you must try delete query in sql as:
它将被删除，但可能是页面没有完全刷新，您会在那里看到数据。但是，如果它仍然没有删除，那么您必须尝试在 sql 中删除查询：
DELETE from your_table_name WHERE your_condition
回答by Rami Dabain
DELETE FROM
yourtable
WHERE
field='value'
AND
field2='value2' ...
LIMIT 1
