User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara No edit summary |
imported>Kymara No edit summary |
||
Line 1:
== cleanup postman table ==
<source lang="sql">
CREATE TABLE IF NOT EXISTS temp_postman
( source VARCHAR(64),
target VARCHAR(64),
message TEXT);
LOAD DATA LOCAL INFILE '/home/katie/workspace/stendhal/postmantable.csv' 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
-- add indices on target and delivered (combined?)
| |||