[CentOS] Syntax Help on a Bash Script

Wed May 4 04:36:57 UTC 2011
Steven Crothers <steven.crothers at gmail.com>

Possibly an invisible character. Delete the entire line with "then"
and re-type it. That error seems odd.


On Wed, May 4, 2011 at 12:33 AM, Robert <bobster58 at gmail.com> 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 at 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.
>
> Bobster
>
>
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>



-- 
Steven Crothers
steven.crothers at gmail.com