sqlite3 db에 접속하여 수집된 데이터 삭제
#!/bin/bash
time=$(date -d'14 day ago' +%Y-%m-%d)
/bin/sqlite3 /root/work/extest/src/ex_conn.sqlite3 "delete from express_resp where exetime < '$time';"
sqlite3 작업 shell script
2021. 8. 3. 15:48
sqlite3 db에 접속하여 수집된 데이터 삭제
#!/bin/bash
time=$(date -d'14 day ago' +%Y-%m-%d)
/bin/sqlite3 /root/work/extest/src/ex_conn.sqlite3 "delete from express_resp where exetime < '$time';"