Reading a row from mysql database and saving fields to user defined variables

Question

0.00/5 (No votes)

See more:

Hi
I would like to know if anyone has any idea on how to achieve the following:

Say i do the following:

SELECT User.Name, User.Surname, User.phone FROM User WHERE User.ID = 1

Now say i want to store the fields returned above to user defined variables.
example:

SET @Name := User.Name
SET @Phone := User.Phone

How do i do this??

And how to i do an if statement in mysql.
Example:

If @Name = John THEN INSERT INTO ADMINTABLE() VALUES()
ELSE IF @Name = Paul THEN INSERT INTO SUPERISOR() VALUES()

How do i achieve the above?

And is there a way to iterate thru each row returned and the run functions against results?

Please someone help with any of the above

Thanks in advance

Posted 25-Sep-12 9:46am

Ashy-G

Add a Solution

Comments

Zoltán Zörgő 25-Sep-12 15:58pm

You want this in a stored procedure?

Ashy-G 25-Sep-12 16:57pm

well doesn't matter if its in a stored procedure or a trigger or a function. Just need to know how you read a row from a table and then store each of field data into user defined variables. Thanks

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rai Pawan · Answer 1 · 2012-11-19T23:36:00

Hi Ashy

I think you can set a variable inside select statement like this:

SELECT

@Name := User.Name, @Phone := User.phone FROM User WHERE User.ID = 1

check this out http://dev.mysql.com/doc/refman/5.0/en/user-variables.html[^]

To get familiar with mysql if else statement please read this:

http://dev.mysql.com/doc/refman/5.0/en/if.html[^]

Regards
Pawan

Please mark the answer as solution if it fulfills your criteria.