前言
写一个简单的shell ,读取linux 目录下的文件内容,将其一一对应插入本地数据库中
mysql shell脚本插入数据
- 文本内容
- 脚本如下,此为while无限循环
#!/bin/bash
IFS='\n'
count=1
while [ $count -eq 1 ]; do
for line in $(cat 123.txt)
do
c1=`echo $line |awk '{print $1}'`
c2=`echo $line |awk '{print $2}'`
c3=`echo $line |awk '{print $3}'`
mysql -uroot -p123 bs_audit <<eof
insert into insert_data(name,age,createTime) values($c1,$c2,$c3);
eof
done
done
Oracle shell脚本插入数据
#!/bin/bash
count=1
while [ $count -eq 1 ];do
cat 123.txt |while read c1 c2 c3
do
sqlplus system/123 <<eof
insert into insert_data(name,age,createTime) values($c1,$c2,$c3);
eof
done
done