New game
Download
Get Academic Plan
Share game
Fill in the Blanks
Fill in the Blanks

Procedure MYSQL

Integrate it into your platform

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

%
Anonymous
Anonymous
%
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Print your game
Procedure MYSQL
 

Fill in the Blanks

Procedure MYSQLOnline version

Procedure MYSQL

by Dulce G
1

IN INTO begin and * sum concat INOUT out

delimiter / /

create procedure sp ( letra char , suma decimal ( 10 , 2 ) )
set suma = ( select ( precio ) from productos where producto like ( letra , '%' ) ) ;
end / /
delimiter ;


2

iner concat on date_format datediff now as upper inner if

delimiter / /
create procedure sp ( )
begin
select ( activo = 1 , " Activo , " Inactivo ) estatus , ( producto ) as producto , ( fecha , '%d / %m / %Y' ) as fechaFormateada , ( producto , ' - ' , precio ) as productoPrecio , tipoProducto from productos join tiposProductos
tiposProductos . idTipoProducto = productos . idTipoProducto ;
end / /
delimiter ;

3

betwen avg out having sum between IN where

delimiter / /
create procedure sp ( id1 int unsigned , iIN d2 int unsigned , promedio decimal ( 10 , 2 ) )
begin
select ( precio ) into promedio from productos idProducto id1 and id2 ;
end / /
delimiter ;

Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.