-bash: syntax error near unexpected token `)’

It is not possible to escape single quote in single quotes. Use " " instead

perl async_sql.pl "UPDATE some_table set i = i + 1 WHERE (n in ('328430','334969','330179','335290','335285','335284','335264','335145','335146','335147','335148','335149','335230','335201','335198','335196','335167','335151','335152','335143','334969','334972','334977','334978','334979','334980','334982','334983','334984','334934','334947','334948','334950','334992','335014','335026','335030','335032','334864','334862','334861','334858','334855','334852','334850','334849','334848','334847','334844','334842'))"


Also, there are other ways to deal with this problem:

echo "quote'test"
echo 'quote'"'"'test'
echo 'quote'\''test'
echo $'quote\'test'

All these should print quote'test as a single parameter. Which means that another great solution for your problem is:

perl async_sql.pl $'UPDATE some_table set i = i + 1 WHERE (n in (\'328430\',\'334969\',\'330179\',\'335290\',\'335285\',\'335284\',\'335264\',\'335145\',\'335146\',\'335147\',\'335148\',\'335149\',\'335230\',\'335201\',\'335198\',\'335196\',\'335167\',\'335151\',\'335152\',\'335143\',\'334969\',\'334972\',\'334977\',\'334978\',\'334979\',\'334980\',\'334982\',\'334983\',\'334984\',\'334934\',\'334947\',\'334948\',\'334950\',\'334992\',\'335014\',\'335026\',\'335030\',\'335032\',\'334864\',\'334862\',\'334861\',\'334858\',\'334855\',\'334852\',\'334850\',\'334849\',\'334848\',\'334847\',\'334844\',\'334842\'))'

I have only placed a dollar sign $ right before the parameter. That’s it. A dollar sign before single quotes turns on ANSI-C Quoting

Related Posts:

  1. How do I split a string on a delimiter in Bash?
  2. Ubuntu says “bash: ./program Permission denied” [closed]
  3. How to concatenate string variables in Bash
  4. An example of how to use getopts in bash
  5. How do I iterate over a range of numbers defined by variables in Bash?
  6. How do I iterate over a range of numbers defined by variables in Bash?
  7. “unary operator expected” error in Bash if condition
  8. What does “-ne” mean in bash?
  9. How to generate random number in Bash?
  10. How to check if a variable is set in Bash?
  11. How can I compare numbers in Bash?
  12. Open and write data to text file using Bash?
  13. How do I set a variable to the output of a command in Bash?
  14. Is there a TRY CATCH command in Bash
  15. Run a string as a command within a Bash script
  16. “No such file or directory” but it exists
  17. How do I pause my shell script for a second before continuing?
  18. In the shell, what does ” 2>&1 ” mean?
  19. Extract substring in Bash
  20. Should I put #! (shebang) in Python scripts, and what form should it take?
  21. Should I put #! (shebang) in Python scripts, and what form should it take?
  22. How do I use a regex in a shell script?
  23. Difference between wait and sleep
  24. Multi-line string with extra space (preserved indentation)
  25. How to delete from a text file, all lines that contain a specific string?
  26. Multi-line string with extra space (preserved indentation)
  27. ‘\r’: command not found – .bashrc / .bash_profile [duplicate]
  28. How to mkdir only if a directory does not already exist?
  29. Loop through an array of strings in Bash?
  30. ‘\r’: command not found – .bashrc / .bash_profile [duplicate]
  31. How can I check if a directory exists in a Bash shell script?
  32. How to set ssh timeout?
  33. commands not found on zsh
  34. sudo: apt-get: command not found
  35. Why do people write #!/usr/bin/env python on the first line of a Python script?
  36. How to mkdir only if a directory does not already exist?
  37. Using find to locate files that match one of multiple patterns
  38. “sed” command in bash
  39. How can I declare and use Boolean variables in a shell script?
  40. Is there a Python equivalent to the ‘which’ command
  41. How can I declare and use Boolean variables in a shell script?
  42. How to reload .bash_profile from the command line?
  43. What is the purpose of “&&” in a shell command?
  44. Replace one substring for another string in shell script
  45. “[ ]” vs. “[[ ]]” in Bash shell
  46. How do I split a string on a delimiter in Bash?
  47. Pseudo-terminal will not be allocated because stdin is not a terminal
  48. Who can access a file with octal permissions “000” on Linux/UNIX?
  49. What is a list in Bash?
  50. What does the line “#!/bin/sh” mean in a UNIX shell script?
  51. How can I count all the lines of code in a directory recursively?
  52. How can I kill a process by name instead of PID, on Linux?
  53. Given two directory trees, how can I find out which files differ by content?
  54. Which characters need to be escaped when using Bash?
  55. How to remove the quotes when reading a variable in jq in shell?
  56. Shell: How to call one shell script from another shell script?
  57. Pseudo-terminal will not be allocated because stdin is not a terminal
  58. find: missing argument to -exec
  59. python getoutput() equivalent in subprocess
  60. ./configure : /bin/sh^M : bad interpreter
  61. What is the $? (dollar question mark) variable in shell scripting?
  62. How to check if an environment variable exists and get its value?
  63. What is the difference between “#!/usr/bin/env bash” and “#!/usr/bin/bash”?
  64. How to convert a string to lower case in Bash?
  65. Is there a “goto” statement in bash?
  66. dquote> result of a execution a program in linux shell
  67. Using sudo with Python script
  68. conditional binary operator expected in shell script
  69. How to specify the private SSH-key to use when executing shell command on Git?
  70. Block Comments in a Shell Script
  71. Sorting data based on second column of a file
  72. Writing a simple shell in C using fork/execvp
  73. Speed up rsync with Simultaneous/Concurrent File Transfers?
  74. Multi-dimensional arrays in Bash
  75. Variable interpolation in the shell
  76. What’s the meaning of the parameter -e for bash shell command line?
  77. zip error – Nothing to do
  78. How to sort an array in Bash
  79. What does set -e mean in a bash script?
  80. What does set -e mean in a bash script?
  81. Check existence of input argument in a Bash shell script
  82. Associative arrays in Shell scripts
  83. How to split one string into multiple strings separated by at least one space in bash shell?
  84. Copy multiple files from one directory to another from Linux shell
  85. Shell script not running, command not found
  86. source command not found in sh shell
  87. How to get a shell environment variable in a makefile?
  88. What are the uses of the exec command in shell scripts? 
  89. using rot13 and tr command for having an encrypted email address
  90. Shell Script: Execute a python program from within a shell script
  91. How to parse XML in Bash?
  92. sed whole word search and replace
  93. Integer expression expected error in shell script
  94. How do I know the script file name in a Bash script?
  95. What is “-bash: !”: event not found”
  96. How to add a timestamp to bash script log?
  97. Colors in bash after piping through less?
  98. What’s the difference betwen the single dash and double dash flags on shell commands?
  99. How to run command as user who has /usr/sbin/nologin as Shell?
  100. How to let ‘cp’ command don’t fire an error when source file does not exist?

Leave a Comment

error code: 523