Slide 30
Slide 30 text
mysql> install plugin chobiedb SONAME 'ha_̲chobie.so';
Query OK, 0 rows affected (0.07 sec)
mysql> CREATE TABLE ranking(
id int unsigned,
score int unsigned,
rank int unsigned
) Engine = ChobieDB;
Query OK, 0 rows affected (0.09 sec)
mysql> insert into ranking(id, score) values(1, 100), (2, 30), (3, 45), (4,
50), (5, 80), (6, 90);
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0
mysql> select * from ranking;
+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+
| id | score | rank |
+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+
| 2 | 30 | 1 |
| 3 | 45 | 2 |
~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼~∼
+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒-‐‑‒+
6 rows in set (0.00 sec)