Thanks Patric. He were go:
select distinct(sal) from bonus where ename like
'MARTIN'
SAL
---------
0,00
1 row selected
NB! It makes no difference if I use sal = 0.0
--- Patrick Bierans <[EMAIL PROTECTED]> wrote:
> > If I use:
> >
> > IF sal = 0 THEN
> > UPDATE bonus set sal = 1250 WHERE ENAME =
> 'MARTIN';
> > END IF;
> >
> > .. the value of sal is not updated with 1250
>
> please execute this statement:
> select distinct(sal) from bonus where ename like
> 'MARTIN';
>
> what is the result?
>
__________________________________
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hrqqlgt/M=362335.6886445.7839731.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1122986183/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
low income neighborhoods, 84% do not own computers. At Network for Good, help
bridge the Digital Divide!</a>.</font>
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
