[TriLUG] mysql syntax for ambiguous file name, please

Michael Rulison 13miketele at bellsouth.net
Sat Jun 16 17:05:28 EDT 2007


I want to do the following query, but it fails:

alter table jos_* rename to j_fca_*;

but the '*' is not accepted (inside, outside of quotes (double or single);

I am sure I don't have to do this table by table for 30+ tables.

Your help much appreciated.

Mike Rulison





More information about the TriLUG mailing list