Shell Programming and Scripting

 
#!/bin/sh  
   
uMYSQLConn="mysql -uUserName -pPassword -hhost_name_or_ip dbname"  
   
uMYSQLConn <<EOF   
select version();  
EOF

mysql --host=192.168.18.52 --user=user1 --password=User1 bugs

 
isql -s server-name -u username -p password

`mysql --host=######## --user=####--password=###bugs<<SQL
$(select * from bugs);
quit
SQL`

sh mysqlcon.sh 
mysqlcon.sh: command substitution: line 6: syntax error near unexpected token `from'
mysqlcon.sh: command substitution: line 6: `select \* from bugs'
release@buildserver IN [/release/releasescript] ON [Fri Jun 17 14:50:22]

 
$(select * from bugs);
 
replace to
 
select * from bugs;

mysql --host=####### --user=#####--password=#####bugs < query.sql