在一个查询中删除少数表的记录 [英] Delete Few Table's Record in One Query
问题描述
任何人都知道如何在Access中创建一个SQL或方法来删除几个表的记录。我的意思是删除指定几个表中的所有记录。
我试图使用查询来删除记录表,但只删除一个表。
任何人都知道更好的方式吗?
shinyo
Anyone know how to create a SQL or way in Access for deleting few tables'' record. I means is delete all the records in specify few tables.
I tried to use query to delete the records'' table but only one table by one query only.
Anyone know the better way?
shinyo
推荐答案
任何人都知道如何在Access中创建一个SQL或方法来删除几个表的记录。我的意思是删除指定几个表中的所有记录。
我试图使用查询来删除记录表,但只删除一个表。
任何人都知道更好的方式吗?
shinyo
Anyone know how to create a SQL or way in Access for deleting few tables'' record. I means is delete all the records in specify few tables.
I tried to use query to delete the records'' table but only one table by one query only.
Anyone know the better way?
shinyo
这取决于您决定从哪个表中删除数据的方式。
是所有桌子还是只是某些桌子?
每次都是相同的表格吗?
这可以在代码中完成,但具体取决于这些问题的答案。
Mary
This depends on how you are deciding which tables you want to delete the data from.
Is it all tables or just certain tables?
Is it the same tables each time?
This can be done in code but how will depend on the answer to these questions.
Mary
这取决于您决定从哪个表中删除数据的方式。
是所有桌子还是只是某些桌子?
每次都是相同的表格吗?
这可以在代码中完成,但具体取决于这些问题的答案。
< br $> b $ b Mary
This depends on how you are deciding which tables you want to delete the data from.
Is it all tables or just certain tables?
Is it the same tables each time?
This can be done in code but how will depend on the answer to these questions.
Mary
例如我在数据库中有10个表。我想删除它们的7个表,但只想删除7个表的内容,而不是它自己的表。考克斯我仍然需要桌子只是想要它是空的。
谢谢你
example i have 10 tables in a database. I want to delete 7 tables of them but just want to delete only the content of the 7 tables but not the tables it self. Cox I still need the table just want it to be empty.
Thank u
例如,我在数据库中有10个表。我想删除它们的7个表,但只想删除7个表的内容,而不是它自己的表。考克斯我仍然需要桌子只是想要它是空的。
谢谢你是
example i have 10 tables in a database. I want to delete 7 tables of them but just want to delete only the content of the 7 tables but not the tables it self. Cox I still need the table just want it to be empty.
Thank u
这是你想要做的事吗定期并且它总是相同的7张桌子。
Mary
Is this something you want to do on a regular basis and will it always be the same 7 tables.
Mary
这篇关于在一个查询中删除少数表的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!