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_name,Data_Type from information_schema.columns; But now we reverted back to 4.1.13 (for releasing on production). But there is no information_schema database in MySQL 4.1.13. So can any one tell me how can I build the data dictionary in MySQL 4.1.13. Thank you sujay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]