On 5/3/11 11:33 PM, Robert wrote:
> Hi All,
>
> I'm brand new at doing anything linux and would like feedback on this
> script I'm trying to understand from an example I'm working on..
>
> Oh, running Centos 5.6
>
> Anyhow, I run this bash script:
>
> #!/bin/bash
> # send data to the table in the MySQL database
>
> MYSQL='which mysql'
>
> if [ $# -ne 4 ]
> then
> echo "Usage: mtest4 empid lastname firstname salary"
> else
> statement="insert into employees values ($1, '$2','$3', $4)"
> $MYSQL test<< EOF
> $statement
> EOF
> If [ $? -eq 0 ]
> then
> echo "Data successfully added"
> else
> echo "Problem adding data"
> fi
> fi
>
>
> and here is the error I get:
>
> [Bobster@localhost ~]$ ./mtest4 5 Johnson John 120000
> ./mtest4: line 15: syntax error near unexpected token `then'
> ./mtest4: line 15: ` then'
>
> Thanks in advance for any inputs.
The If on line 14 should be if (lowercase).
--
Les Mikesell
lesmikesell@xxxxxxxxx
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
