[Phpmyadmin-devel] MySQL queries

[Piotr Przybylski]

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