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 1: | Line 1: | ||
== cleanup postman table == |
== cleanup postman table == |
||
<source lang="sql"> |
<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?) |
-- add indices on target and delivered (combined?) |
||