New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
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.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Fill in the Blanks
Fill in the Blanks

Osnove MySQL

Integrate it into your platform
G. Classroom M. Teams
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.

Get Academic 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.

Get Academic 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:

Get Academic Plan
%
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.

Get Academic Plan
Print your game
Osnove MySQL
 

Fill in the Blanks

Osnove MySQLOnline version

DDL, DML

by Romana Kolar
1

DATABASES FROM SELECT INDEX DATABASE Jezik WHERE BY TRIGGER ALTER TABLE ORDER VIEW INSERT DELETE UPDATE

DDL zajema naslednje ukaze : CREATE , , DROP . Z njimi lahko definiramo - zbirke podatkov - , tabele - , indekse - , poglede - , pro ? ilce - .
Podatkovno zbirko ustvarimo z naslednjim ukazom :
CREATE DATABASE ime_podatkovne_zbirke .
? e nas zanima katere podatkovne baze imamo ustvarjene , to ugotovimo z ukazom :
SHOW .
Ko dolo ? ene podatkovne zbirke ne potrebujemo ve ? , jo zbri ? emo z ukazom :
DROP DATABASE ime_podatkovne_zbirke .
V jeziku DML uporabljamo naslednje ukaze :
- Za izbiranje -
- Za brisanje -
- Za dodajanje -
- Za spreminjanje - .
Ukaz dolo ? a tabele za poizvedbo , ukaz Dolo ? a vrstni red vrstic na izhodu , ukaz filtrira vrstice .

 
Are you sure you want to leave the page?

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