Re: procedure in oracle

[Roland Bouman]

mou lei wrote:
> I have a procedure in oralce
>
> begin
> v_row table%ROWTYPE;--how can i declare this in
> mysql
> end;
>

mmm I doubt it, In oracle it would be:

declare
v_row table%ROWTYPE;--how can i declare this in
begin
null;
end;

anyway - MySQL does not support the %TYPE or %ROWTYPE syntax. You will just have to declare as many inidividual variables as you need.

> another problem is
> the function NVL in oracle
> can i find some insead in mysql?
>
> thanks a lot

for

NVL(a,b)

use

COALESCE(a,b)

(which is defined in the SQL Standard)

or

IFNULL(a,b)