468,510 Members | 1,712 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,510 developers. It's quick & easy.

What is the syntax for parameter query in mysql

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
1 2058
Rabbit
12,513 Expert Mod 8TB
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.

Similar topics

2 posts views Thread by John Jayaseelan | last post: by
2 posts views Thread by John Jayaseelan | last post: by
1 post views Thread by jmarr02s | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.