By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

What is the syntax for parameter query in mysql

P: 48
my question is basically how to pass a parameter to a query in mysql. lets say i have a table with empno and empname and i want to select the empno based on the empname entered by the user. something like
Expand|Select|Wrap|Line Numbers
  1. select empno from mytable
  2. where empname=[enter employee name];
  3.  
i know this will work in access but in mysql it give me syntax error.
Jan 20 '12 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,324
You should post this in the MySQL forum.
Jan 20 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.