User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara No edit summary |
imported>Kymara No edit summary |
||
| Line 8: | Line 8: | ||
LOAD DATA LOCAL INFILE '/home/katie/workspace/stendhal/postmantable.csv' |
LOAD DATA LOCAL INFILE '/home/katie/workspace/stendhal/postmantable.csv' |
||
INTO TABLE temp_postman FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
INTO TABLE temp_postman FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
||
Query OK, 935 rows affected (0.00 sec) |
|||
Records: 935 Deleted: 0 Skipped: 0 Warnings: 0 |
|||
insert into postman (source, target, message, timedate, messagetype, delivered) |
|||
select source, target, message, '2010-07-20 00:00:00', 'P', 0 from temp_postman; |
|||
-- yes thats a lie about the message type, some came from npcs |
|||
-- add indices on target and delivered (combined?) |
-- add indices on target and delivered (combined?) |
||