Icon New game New game

Comandos SQL 2

Fill in the Blanks

Complete el siguiente código SQL con los comandos adecuados

Download the paper version to play

32 times made

Created by

Mexico

Top 10 results

  1. 1
    00:44
    time
    100
    score
  2. 2
    00:49
    time
    100
    score
  3. 3
    01:25
    time
    67
    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
 
game-icon

Fill in the Blanks

Comandos SQL 2Online version

Complete el siguiente código SQL con los comandos adecuados

by MARIO ALBERTO NEGRETE GOMEZ
1

DATABASE TABLE PRIMARY

CREATE mydb ;
USE mydb ;
CREATE mitabla ( id INT KEY , nombre VARCHAR ( 20 ) ) ;

2

INTO VALUES SELECT INSERT WHERE

INSERT mitabla ( 1 , 'Will' ) ;
INSERT INTO mitabla VALUES ( 2 , 'Marry' ) ;
INTO mitabla VALUES ( 3 , 'Dean' ) ;
id , nombre FROM mitabla id = 1 ;

3

count UPDATE DELETE FROM DROP

mitabla SET nombre = 'Willy' WHERE id = 1 ;
SELECT id , nombre mitabla ;
FROM mitabla WHERE id = 1 ;
SELECT id , nombre FROM mitabla ;
[ DATABASE mydb ;
SELECT ( 1 ) from mitabla ; da el número de registros en la tabl a

educaplay suscripción