[求IT大牛帮忙]shell脚本,操作数据库(informix数据库),求IT大牛帮忙
发布网友
发布时间：2022-10-16 07:39
共1个回答
热心网友
时间：2023-10-17 05:22
#! /bin/sh
dbaccess aadb 2>/dev/null << !SQL
unload to sql.txt DELIMITER " "
select * from info where date[1,4]=YEAR(CURRENT) and date[5,6]=MOUTH(CURRENT) and date[7,8]=DAY(CURRENT)
!SQL
if (wc -l sql.txt = 0);then
dbaccess aadb2>/dev/null <<!SQL
insert into info values("?","?")
!SQL
fi追问你好,你在吗? 我还有类似的问题要请教.我企鹅908517099 麻烦你加一下呗
