Pelotoni mälumäng
küsimus nr: 1
meie õppesõidu 412 oli kuskil kaheksakümnendate keskel tehtud ja sellel olid täistuled roolisambalt vasaku kangiga
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SHOW FULL COLUMNS FROM `mangKysimused` | 6 | 6 | 1 | |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_general_ci'; | 1 | 1 | 1 | |
| 3 | SELECT `Game`.`id`, `Game`.`aeg`, `Game`.`nimi`, `Game`.`orig_text`, `Game`.`kysitud`, `Game`.`vastatud` FROM `mangKysimused` AS `Game` WHERE 1 = 1 ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 214 | |
| 4 | SELECT COUNT(*) AS `count` FROM `mangKysimused` AS `Game` WHERE `Game`.`id` = 548214 | 1 | 1 | 65 | |
| 5 | SELECT COUNT(*) AS `count` FROM `mangKysimused` AS `Game` WHERE `Game`.`id` = 548214 | 1 | 1 | 30 | |
| 6 | UPDATE `mangKysimused` SET `id` = 548214, `aeg` = '2006-08-04 13:24:00', `nimi` = 'uzi', `orig_text` = 'meie õppesõidu 412 oli kuskil kaheksakümnendate keskel tehtud ja sellel olid täistuled roolisambalt vasaku kangiga', `kysitud` = 1, `vastatud` = NULL WHERE `mangKysimused`.`id` = 548214 | 1 | 678 | ||
| 7 | select distinct nimi from mangKysimused order by nimi | 20 | 20 | 85 |