Question

xcode使用sqlite3，如何检查数据库中存不存在某张表，请指点一下

Answer 1

[root@yang testshell]# cat tabletest.sh
#!/bin/bash
su - oracle <<ok
fuckyou(){
sqlplus /nolog <<fuck
conn scott/yk123;
select table_name from user_tables;
exit;
fuck
}
fuckyou >>/home/oracle/output.txt;
exit
ok
#fuckyou >>/home/oralce/output.txt;
read -p "please input tablename: " -t 5 tablename
tn=$(echo ${tablename} |tr [a-z] [A-Z])
grep -l "${tn}" /home/oracle/output.txt && echo "the table ${tablename} exist.";
[root@yang testshell]#sh tabletest.sh
please input tablename: emp
/home/oracle/output.txt
the table emp exist.
[root@yang testshell]#

请仔细阅读。