Hello.
The common way is to use different 'SHOW' statements, for example
'SHOW CREATE TABLE'. Sometimes mysqldump with --no-data helps a lot.
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Initially I used MySQL 5.0.4 for all my development. At that time I used the
> following
Hi,
Initially I used MySQL 5.0.4 for all my development. At that time I used the
following SQL query to load the whole data dictionary into my local memory
to reduce load on DB as I am using the prepared statements API, that
requires column types as one of the inputs.
select Table_Name,column_n