I want to populate a shell script variable with the result of a select count(*) sql statement. At the moment I can select the results and write them to a file but now I just want to get the count and populate a shell script varaiable with the value
i.e. I want the variable 'COUNT' to be populated with the result of 'Select count(*) from Table'
I'm a newcomer to shell scripting to so any help would be greatly appreciated