Re: Getting the data dictionary in MySQL 4.1.13

2005-08-10 Thread Gleb Paharenko
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

Getting the data dictionary in MySQL 4.1.13

2005-08-10 Thread Sujay Koduri
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