sqlite3的运用(shell)

①在终端下进入sqlite命令行：

 sqlite3 20190507.db

 ②退出命令行：

.q

  ③查看表结构：

select * from sqlite_master WHERE type = "table";

  ④shell脚本中执行sql语句：

sqlite3 /work/songqiang/test.db << !
delete from company where age= '18' ;
select 'import: '||count(*) from company ;
.q
!

   ⑤拼接sql语句：

select pthread_type, cdr_id, duration ,'{sum}',duration/('{sum}'+0) 
                from tot_info 
                where file_name = '{file_name}'
                order by duration desc ;'''.format(file_name=filename,sum=cds[0][0])

  ⑥sql中将字符串转换为数字：

SELECT '123'+0;