Suche auf lima-city
-
in: How to ask MySQL to prompt for values in a query?
geschrieben von dailyxe
I am doing a lot of trial and error with some SQL query in MySQL console e.g.
select fname, age, address from person where lname = ?;
I want to get a prompt asking me for the value of lname, so that I can repeat the query with different values easily. The ? works in case the query is from Java code.
Is it possible in MySQL console, if yes, how?