MySQL Pass an argument / value to a query

Question

I am wondering if it is possible when running a MySQL select statement, that a user input is prompted.

Example: I want to find out the the total number of products sold and multiply it by (User input).

Is this possible in MySQL?

Thanks.

Someone asked the same as you before. You can check the answers here — ealves
– ealves, Commented Dec 5, 2011 at 11:21
thanks ealves I had a look at that but I wasn't sure if it was the same question. — StefanHanotin
– StefanHanotin, Commented Dec 5, 2011 at 11:24

Andreas Wederbrand · Accepted Answer · 2011-12-05 11:19:38Z

1

Not within MySQL client (the normal client shipped with MySQL). You could write your own script to do it or with any luck find someone else who already has. But it's not built in.

answered Dec 5, 2011 at 11:19

Andreas Wederbrand

40.5k12 gold badges71 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Pass an argument / value to a query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related