We're running an application that creates table names in a numeric sequence. For example:

jst0000998_foo
jst0000998_bar
jst0000999_foo
jst0000999_bar
jst0001000_foo
jst0001000_bar
jst0001001_foo
jst0001001_bar

I need to write a maintenance app that first needs to determine the numeric range of existing tables. In the above example it would be 998 to 1001.

What would be a half-way efficient way of doing this?

MySQL version is 3.21.x, with MyISAM tables.


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to