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

Views y procedures BDAvanzada

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
Download the game as a Scorm, HTML, or PDF file.
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:

Views y procedures BDAvanzada

Fill in the Blanks

(5)
Estructura de views y procedures (mysql)

Download the paper version to play

Recommended age: 16 years old
85 times made

Created by

Mexico

Top 10 results

  1. 1
    01:11
    time
    100
    score
  2. 2
    ManuelManuelon
    ManuelManuelon
    01:17
    time
    100
    score
  3. 3
    4F LTI
    4F LTI
    01:46
    time
    100
    score
  4. 4
    ManuManiManito
    ManuManiManito
    01:56
    time
    100
    score
  5. 5
    02:00
    time
    100
    score
  6. 6
    barbie
    barbie
    02:05
    time
    100
    score
  7. 7
    dulce
    dulce
    02:33
    time
    100
    score
  8. 8
    02:50
    time
    100
    score
  9. 9
    5F LTI
    5F LTI
    02:52
    time
    100
    score
  10. 10
    JesusDLC
    JesusDLC
    04:31
    time
    100
    score
Do you want to stay in the Top 10 of this game? to identify yourself.
Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game

Top Games

  1. time
    score
  1. time
    score
time
score
time
score
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
 
game-icon

Fill in the Blanks

Views y procedures BDAvanzadaOnline version

Estructura de views y procedures (mysql)

by Dulce G
1

view delete update IN procedure delimiter values begin select

$$
create sp_insert ( pais_ varchar ( 50 ) ) insert into paises ( pais ) ( pais_ ) ;
end $$
delimiter ;

2

procedure update as drop view delete from create

view_paises select * paises ;

3

view start join drop from delete ON in out

delimiter $$
create procedure sp_paises_estados ( )
begin
select pais , estado paises inner estados estados . idpais = paises . idpais ;
end $$
delimiter ;

4

where select drop from IN out

delimiter $$
create procedure sp_eliminar ( id int )
begin
delete paises idpais = id ;
end $$
delimiter ;

5

INTO OUT FROM IN

delimiter $$
create procedure sp_suma ( suma int )
begin
select sum ( precio ) suma productos ;
end $$
delimiter ;

6

as by on year offset dateformat limit datediff upper for

delimiter $$
create procedure sp_listar ( )
begin
select ( pais ) as pais , ( fecha_publicacion ) fecha from paises order pais desc 4 ;
end $$
delimiter ;