I'm in the process of trying to move some of our systems to MySQL from SQL Server and Oracle. At this point I'm learning and testing MySQL.
One immediate question I have is regarding getting aggregate information. For example, the SHOW DATABASES command would be an example of something I would get from the SQL Server data dictionary table, sysdatabases. It appears that MySQL has no such mechanisms, and that you must rely on many of the SHOW commands. In the case of databases, it works great, but what about other objects? For example, if I want to see all indexes in my sales database? Or do I have to loop through each table with the SHOW INDEXES command? That's one example of what I'm talking about. Thanks so much for the help. Lou Olsten [EMAIL PROTECTED]
