how to write sqlite update operation in two tables?
Posted
by sxingfeng
on Stack Overflow
See other posts from Stack Overflow
or by sxingfeng
Published on 2010-06-18T03:13:25Z
Indexed on
2010/06/18
3:33 UTC
Read the original article
Hit count: 220
I am using SQLite,
TABLE A
(
ID
FileNAME
FOLDERID
)
TABLE B
(
FOLDERID
FOLDERPATH
)
I want to write a sql statement to delete all files in A where its Folder is subfolder of C:\ABC\; How Can I make it in one sqlite statement, and is it the best way to do?
Many thanks!
© Stack Overflow or respective owner