[Phpmyadmin-devel] MySQL queries
piotr.prz at gmail.com
Thu Mar 31 16:37:23 CEST 2011
2011/3/31 Michal Čihař <michal at cihar.com>:
> 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
> 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.
More information about the Developers