More Fun With Bash Quoting

Nov 24, 2009, 12:32 (2 Talkback[s])
(Other stories by Mitch Frazier)

"...case in point: trying to script the updating of a field in a mysql table when the field to be changed contains quote characters.

"Let's imagine we have a simple table with the following data and we would like to change the name field:

+----+----------------------+---------------------+
| id | name                 | create_date         |
+----+----------------------+---------------------+
|  1 | name 'with' "quotes" | 2009-11-19 08:48:59 |
+----+----------------------+---------------------+

"Your first script might look something like this:"

Complete Story

Related Stories:

• Tech Tip: Find Directories Over a Certain Size(Nov 18, 2009)
• 10 Special Linux Distributions That You Should Know(Nov 18, 2009)
• Command line tricks for smart geeks(Nov 17, 2009)
• Looping the Easy Way(Nov 13, 2009)
• Useless Linux Terminal Commands(Oct 21, 2009)
• Getting comfortable with Linux plumbing(Oct 17, 2009)
• Matching Newlines in Vim(Oct 14, 2009)
• More on Using Bash's Built-in /dev/tcp File (TCP/IP)(Oct 01, 2009)