This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
projects:wifi_scanner [2020/01/06 23:44] neil |
projects:wifi_scanner [2020/01/06 23:53] neil |
||
---|---|---|---|
Line 50: | Line 50: | ||
<code sql> | <code sql> | ||
load data infile 'trimmed_tcpdump.log' into table wifi_data; | load data infile 'trimmed_tcpdump.log' into table wifi_data; | ||
+ | </code> | ||
+ | |||
+ | Once I imported all the data I added an index to the mac address column: | ||
+ | <code sql> | ||
+ | alter table simple_data add index idx_mac(mac); | ||
</code> | </code> | ||