腳本放置*.db同目錄下,執(zhí)行即可
dbfile=`find -name "*.db"`
chmod 777 *
echo $dbfile
for f in $dbfile
do
echo "========="
echo $f
tables=`sqlite3 $f ".tables"`
for j in $tables
do
echo "====查表內(nèi)容寫(xiě)入開(kāi)始======="
sqlite3 $f "select * from $j" >> result
"=============" >>result
done
done