You can't do it in a single command, but you can at least close each table with a single command, like this: USE IN mytable1. This will be significantly faster because SELECTing a work area is a relatively slow process.
>Is there an easier way of closing a bunch of tables, but not all the tables, than:
>
>SELECT mytable1
>USE
>SELECT mytable2
>USE
>
>Etc?
>
>What I'd like is something like:
>
>CLOSE TABLES mytable1, mytable2
>
>But what I read in the help about CLOSE TABLES doesn't sound like you can do that. Is there another command for that?