User talk:Kymara: Difference between revisions

== elfy ==

mysql> create table temp_elf_princess select timedate, source from gameEvents where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought' and id < 58379295;

Query OK, 562 rows affected (6.22 sec)

Records: 562 Duplicates: 0 Warnings: 0

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';

Query OK, 346 rows affected (5.67 sec)

Records: 346 Duplicates: 0 Warnings: 0

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';

Query OK, 393 rows affected (6.40 sec)

Records: 393 Duplicates: 0 Warnings: 0

insert into temp_elf_princess select timedate, source from gameEvents_2008_08_21 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';

Query OK, 131 rows affected (49.79 sec)

Records: 131 Duplicates: 0 Warnings: 0

mysql> select count(*) from temp_elf_princess;

+----------+

| count(*) |

+----------+

| 1432 |

+----------+