Re: [Phpmyadmin-devel] MySQL queries

2011/3/31 Michal Čihař michal@cihar.com:

Hi

Dne Thu, 31 Mar 2011 20:00:45 +0530 Samiran Raj Boro srajbr@gmail.com napsal(a):

...

information_schema is an ANSI standard and should be used instead of

...

DBMS specific extensions whenever possible. It will also make Drizzle support easier to implement, as they have dropped mysql database.

So, I guess I will have to purse the output of SHOW CREATE statement to retrieve parameter list for MySQL Ver < 5.5 for being compatible with Drizzle

For case of MySQL < 5.5, you get get the data from mysql table as well. I think it's better solution than parsing SHOW CREATE output.

Yes, use mysql table when information_schema is unavailable. You can check for MySQL version in PMA_MYSQL_INT_VERSION constant.