Re: user input - 04-11-2005 , 09:07 PM
Stan Cook wrote:
SQL*Plus, I don't think the MySQL command-line interface has that feature.
You need to do this in some kind of application code. Prompt the user
for input using your favorite programming language, use their input
while constructing a SQL query, then execute that query.
Example in Bourne shell:
echo -n "Enter a value: "
mysql mydatabase -e "select * from mytable where myfield = '$value';'
(nb: example not tested)
Re: user input - 04-11-2005 , 10:34 PM
That's what I suspected.... Thanks...
Bill Karwin <bill (AT) karwin (DOT) com> wrote: