user input

#1

How do you write a query which will stop ans wait
for user input?

Stan

#2

Stan Cook wrote:

Quote:

How do you write a query which will stop ans wait for user input?

If you mean something like the Oracle "&" prompt for user input in
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: "
read value
mysql mydatabase -e "select * from mytable where myfield = '$value';'

(nb: example not tested)

Regards,
Bill K.

#3

That's what I suspected.... Thanks...

Regards...
Stan

Bill Karwin <bill (AT) karwin (DOT) com> wrote:

Quote:

Stan Cook wrote:

How do you write a query which will stop ans wait for user input?

If you mean something like the Oracle "&" prompt for user input in 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: "
read value
mysql mydatabase -e "select * from mytable where myfield = '$value';'

(nb: example not tested)

Regards,
Bill K.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

user input

mailing.database.mysql mailing.database.mysql

user input - 04-11-2005 , 07:49 PM

Re: user input - 04-11-2005 , 09:07 PM

Re: user input - 04-11-2005 , 10:34 PM