User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara No edit summary |
imported>Kymara No edit summary |
||
Line 8:
LOAD DATA LOCAL INFILE '/home/katie/workspace/stendhal/postmantable.csv'
INTO TABLE temp_postman FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
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?)
| |||