SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE procedure `test`(`M` INT, `D` INT) BEGIN set @m = m; set @d = d; set @i = @m-@d; set @size = 4 * floor( @i/9 ); set @size = @size + ceil( (@i % 9) / 2 ); set @size = @size + 4 * floor( @d/9 ); set @size = @size + ceil( (@d % 9) / 2 ); select @size; END;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear