Hi
i am trying to insert data into mysql database using mysql client
for example :
$firstname=eyal
$lastname=sperling
shell 'mysql -u root test -e "insert into info(first,last) values ('$first','$last')"'

this mysql command is running fine from command line but not from shell ... i guess the problem is the quotes around the values . i tried several combination of single/double quotes but none of them works . any idea ?

Thanks
eyal