5

Sql issue in shell scripting

view full story
linux-howto

http://www.unix.com – HI friends , i am also facing an issue in mysql i ma trying to insert detail in a variable but not got success Code: #!/bin/sh mysql -u<username> -p<password> <dbname> << EOF DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"` EOF echo $DEV ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1354888190' at line 1 its means i am gettting result. but why ia m getting result (HowTos)