User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara →loots for achievements: new section |
imported>Kymara |
||
Line 120:
== elfy ==
<source lang = "sql">
Query OK, 562 rows affected (6.22 sec)
Records: 562 Duplicates: 0 Warnings: 0
-- yeah I could have done a union but I wanted to know counts and have more control
mysql> insert into temp_elf_princess select timedate, source from gameEvents_2009_08_17 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';▼
insert into temp_elf_princess
select timedate, source from gameEvents_2009_08_17
▲
Query OK, 346 rows affected (5.67 sec)
Records: 346 Duplicates: 0 Warnings: 0
insert into temp_elf_princess
mysql> insert into temp_elf_princess select timedate, source from gameEvents_2009_02_19 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';▼
select timedate, source from gameEvents_2009_02_19
▲
Query OK, 393 rows affected (6.40 sec)
Records: 393 Duplicates: 0 Warnings: 0
insert into temp_elf_princess
insert into temp_elf_princess select timedate, source from gameEvents_2008_08_21 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';▼
select timedate, source from gameEvents_2008_08_21
▲
Query OK, 131 rows affected (49.79 sec)
Records: 131 Duplicates: 0 Warnings: 0
▲mysql> select count(*) from temp_elf_princess;
+----------+
| count(*) |
Line 144 ⟶ 150:
| 1432 |
+----------+
</source>
== loots for achievements ==
| |||