我在查询中只删除一行时需要帮助。 [英] I need help with deleting just a single row in my query.

问题描述

当我转到我构建的查询时，我试图从中删除一行，并删除与该特定客户相关的所有行。如何设置我的查询只删除一行而不是所有行？

When I go to a query that I build, I'm trying to delete just one row from it, and it deletes all the rows that is related to that particular customer. How do I set my query to delete just one row and not all the rows?

推荐答案

您必须对查询使用WHERE子句，

You must use a WHERE clause to the Query,

DELETE * FROM customerTable
WHERE customerID = 75;

这篇关于我在查询中只删除一行时需要帮助。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！