Thanks Patric. Here we 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,00.
> --- 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
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hdn6bhn/M=362329.6886308.7839368.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1122986456/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992
">Fair play? Video games influencing politics. Click and talk back!</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/
