- 论坛徽章:
- 0
|
各位大侠,我看一本shell编程的书,有个例子执行会出现错误,代码如下:
$cat test23
#!/bin/bash
# read file and create INSERT statements for MySQL
outfile='members.sql'
IFS=','
while read lname fname address city state zip
do
cat >> $outfile << EOF
INSERT INTO members (lname,fname,address,city,state,zip) VALUES
('$lname', '$fname', '$address', '$city', '$state', '$zip');
EOF
done < ${1}
$ cat members.csv
Blum,Richard,123 Main St.,Chicago,IL,60601
Blum,Barbara,123 Main St.,Chicago,IL,60601
Bresnahan,Christine,456 Oak Ave.,Columbus,OH,43201
Bresnahan,Timothy,456 Oak Ave.,Columbus,OH,43201
执行后显示以下错误,谁能讲讲是什么原因?
$ ./test23 < members.csv
./test23: line 9: syntax error near unexpected token `('
./test23: line 9: `INSERT INTO members (lname,fname,address,city,state,zip) VALUES '
|
|