CODEWITHSUNDEEP
mysqlarguments
StefanHanotin
StefanHanotin

Reputation: 301

MySQL Pass an argument / value to a query

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.

Upvotes: 0

Views: 90

Answers (1)

Andreas Wederbrand
Andreas Wederbrand

Reputation: 39951

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.

Upvotes: 1

Related Questions