this (old as alabama)
application. They refuse to support newer versions of MySQL.
- Original Message - From: "Eric Bergen" <[EMAIL PROTECTED]>
To: "Jim McAtee" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 02, 2005 11:31 AM
Subject: Re: Determining if a table exists
riginal Message - From: "Eric Bergen" <[EMAIL PROTECTED]>
To: "Jim McAtee" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 02, 2005 11:31 AM
Subject: Re: Determining if a table exists
I don't remember what commands are available in 3.21 but try these
show tables like &
is 3.23.x. Dictated by this (old as alabama)
application. They refuse to support newer versions of MySQL.
- Original Message -
From: "Eric Bergen" <[EMAIL PROTECTED]>
To: "Jim McAtee" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, May 02, 2005 11:31 AM
Subject: R
I don't remember what commands are available in 3.21 but try these
show tables like 'table_name';
then check mysql_num_rows on the result.
describe table;
check mysql_num_rows
show tables;
then pick out the table name;
3.21 is old as alabama (forrest gump) it's time for an upgrade :)
Jim McAtee wro
We're running an application that creates table names in a numeric
sequence. For example:
jst998_foo
jst998_bar
jst999_foo
jst999_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
