If you have the MySQL Reference Manual, see section 3.3.4.9 Using More Than One Table, section 14.1.7 Select, and section 14.2.7 Drop Index. You should be able to work out the command syntax from those three sections.
Basically, open all tables with the Portscan value, Select those items with a Portscan value, and Drop Index to drop them from the tables.
Last edited by bigrigdriver; 01-12-2006 at 06:16 PM.
|