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@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@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@centos.org http://lists.centos.org/mailman/listinfo/centos

On Tue, 2011-05-03 at 23:33 -0500, Robert wrote:

MYSQL='which mysql'

Also this line should use either backticks or $() command substitution instead:

For example:

[andrew@savoy ~]$ MYSQL='which mysql' [andrew@savoy ~]$ echo $MYSQL which mysql [andrew@savoy ~]$ MYSQL=$(which mysql) [andrew@savoy ~]$ echo $MYSQL /usr/bin/mysql [andrew@savoy ~]$ MYSQL=`which mysql` [andrew@savoy ~]$ echo $MYSQL /usr/bin/mysql

Cheers!

--

Andy

On Tue, May 03, 2011 at 11:33:52PM -0500, Robert wrote:

#!/bin/bash # send data to the table in the MySQL database

MYSQL='which mysql'

You want "MYSQL=$(which mysql)"

  If [ $? -eq 0 ]
  then
       echo "Data successfully added"
  else
       echo "Problem adding data"
  fi

"If" is incorrect.

John