awk print: howto single quote not interpreted!?

Shell Programming and Scripting
1 
 	cat a | awk -F";" '{print "update db set column=' "$2" ' where column1=\""$1"\";"}' > ip-add.sql

Hi! I'm a new user!
i need to use single quote in the double quotes print string
The apex between che "$2" should not be interpreted, but....how?!
I'm trying to use \ but don't work correctly!

Thanks!!!!!!

2

try:

awk -F";" '{print "update db set column=\x27"$2"\x27 where column1=\""$1"\""}'
3

Or:

awk -F";" '{print "update db set column="q$2q" where column1=\""$1"\";"}' q="'"
4

Thanks! works!
I would never have done alone! I'm at work and I've blocked in a shell scripting for this.

thanks again!
Carmine

5

or another approach:-

awk -F";" '{print "update db set column=""\047"$2"\047"" where column1=\""$1"\";"}'  infile

:cool::cool::cool: