sasha@stripped wrote:
>
> John Cartwright wrote:
> >
> > Hello All,
> >
> > Is there an alternate way to get the table names in a database other
> > than "show tables"? I'm looking a something like a select-type
> > statement. The problem that I'm having is that the "column name" in the
> > result set for a "show tables" command is different in 3.23 vs. 3.22;
> > "Tables in sgd" vs. "Tables_in_sgd". Even if I could use an alias, it
> > would solve the problem. Something like "show tables as tables"
> >
> > I'm familiar with the mysqlshow command, but I need something that I can
> > execute within JDBC.
> >
> > Thanks for any help or suggestions!
> >
>
> try
>
> show tables like ...
>
> --
> Sasha Pachev
That aint' gonna fix it... the pseudo column name of the result is still
different.
John: I think you may be out of luck, you're probably going to have to
deal with
the difference in your java code, this changed in the new version as you
said and I
had to change my code to use the column index rather than the name,
since there is only
one column in the result set it is no big deal.
