[Phpmyadmin-devel] MySQL queries

Piotr Przybylski piotr.prz at gmail.com
Thu Mar 31 16:37:23 CEST 2011

2011/3/31 Michal Čihař <michal at cihar.com>:
> Hi
> Dne Thu, 31 Mar 2011 20:00:45 +0530
> Samiran Raj Boro <srajbr at 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.

Piotr Przybylski

More information about the Developers mailing list