如何在 FoxPro 中修改或运行此查询？

发布于 2024-10-26 09:40:33 字数 208 浏览 1 评论 0原文

我有这样的 SQL 查询

   select * from tablename  where Fieldname not in (10005347797,1006009285)

我的目标是删除不在该 id 中的剩余记录。因此，在此之前我想查看该表中将要删除的所有记录。
如果您知道如何删除该记录，也可以给我删除命令。

原文

I have the SQL query like this

   select * from tablename  where Fieldname not in (10005347797,1006009285)

My aim is to delete remaining records not in that id.So before that I want to see all the records in that table those are going to be deleted.
If you know how to delete that records you can give me delete command also.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

风筝在阴天搁浅。 2024-11-02 09:40:33

以下代码演示了如何使用SQL命令删除记录。

CREATE CURSOR Table1 (pk I)
INSERT INTO Table1 (pk) VALUES(1)
INSERT INTO Table1 (pk) VALUES(2)
INSERT INTO Table1 (pk) VALUES(3)
INSERT INTO Table1 (pk) VALUES(4)
INSERT INTO Table1 (pk) VALUES(5)

SELECT Table1.* FROM Table1 WHERE Table1.pk NOT IN (2, 4)

DELETE FROM Table1 WHERE Table1.pk NOT IN (2, 4)

The following code demonstrates how to use a SQL command to delete records.

CREATE CURSOR Table1 (pk I)
INSERT INTO Table1 (pk) VALUES(1)
INSERT INTO Table1 (pk) VALUES(2)
INSERT INTO Table1 (pk) VALUES(3)
INSERT INTO Table1 (pk) VALUES(4)
INSERT INTO Table1 (pk) VALUES(5)

SELECT Table1.* FROM Table1 WHERE Table1.pk NOT IN (2, 4)

DELETE FROM Table1 WHERE Table1.pk NOT IN (2, 4)

回复收藏 0 原文

迷离° 2024-11-02 09:40:33

用于为您获取结果的 FoxPro 命令：

BROWSE LAST FOR NOT INLIST(FIELDNAME, 10005347797, 1006009285) && view/edit the records
DELETE FOR NOT INLIST(FIELDNAME,10005347797, 1006009285) && mark the records for deletion
PACK && permanently delete the marked records

注意：根据我使用 FoxPro 的经验，这些命令应该适用于任何版本的 FoxPro。然而它没有经过测试。

FoxPro commands to get the result for you:

BROWSE LAST FOR NOT INLIST(FIELDNAME, 10005347797, 1006009285) && view/edit the records
DELETE FOR NOT INLIST(FIELDNAME,10005347797, 1006009285) && mark the records for deletion
PACK && permanently delete the marked records

Note: Based on my experience with FoxPro, these commands should work with any version of FoxPro. However it is not tested.

回复收藏 0 原文