Principal Software Engineer/Architect, motorcyclist, drummer, and artist
I was trying to run Oracle SQL Developer for the first time on a new machine. When firing it up, it presented me with a dialog box asking me to “Enter the full pathname for the java.exe file”.
OK, no problem. So I find the path to the java.exe binary that was just installed with the SDK. Hit submit . . . and nothing happens. It blanks out the text field and the dialog box stares back at me.
If you would like to, in a shell script, dynamically generate SQL queries for MySQL and save the output of those queries to a variable that you can then use in the script, here is an example:
#!/bin/bash
for i in `cat tables_list.txt`
do
# Build the query
QUERY="SELECT count(*) FROM ${i}"
# Run the query from the command-line and save the
# output into the $ROW_COUNT variable
ROW_COUNT=$(echo $QUERY | mysql -u${USER_NAME} -p${PASSWORD} -h ${HOST} -P ${PORT} --skip-column-names ${DBASE})