reset password
Author Message
HelloWorld
Posts: 88
Posted 17:20 Jul 18, 2009 |

What happened when SELECT INTO doesn't result in anything? What is being stored in the INTO variable? How do we check if it finds it or not?

HelloWorld
Posts: 88
Posted 19:21 Jul 18, 2009 |
HelloWorld wrote:

What happened when SELECT INTO doesn't result in anything? What is being stored in the INTO variable? How do we check if it finds it or not?

Actually i got this already, thanks!

cysun
Posts: 2935
Posted 11:43 Jul 19, 2009 |
HelloWorld wrote:

What happened when SELECT INTO doesn't result in anything? What is being stored in the INTO variable? How do we check if it finds it or not?

You should get NULL(s), and the special variable FOUND will be set to false.