Le 2013-06-14 15:51, Supun Nakandala a écrit :
Hi,
I am transferring the regex statements in the method
PMA_getDisplayPropertyParams($sql_query, $is_select) in sql.lib.php to
the sql analyzer. I feel like some of the regex expressions are not
valid (eg. GROUP SELECT). I would appreciate if someone can validate
these regex statements and provide some test queries or guide me so that
I can gain the required knowledge in order to test the functionality.
Regards Supun
Hi Supun,
first, please use bottom-posting on this list.
Second, are you talking about the regex used to set $is_group? I believe
that all these expressions are correct unless you can point us to
something suspicious.
To gain the required knowledge, you must be familiar with MySQL syntax.
Have a look at [0].
[0]
http://dev.mysql.com/doc/refman/5.5/en/language-structure.html
--
Marc Delisle
http://infomarc.info