just one idea: PMA always shows the SQL it created, so couldn't we just add a small checkbox and a textinput giving the user the possibility to add a variablename and then to have a second output of the SQL in the form of
$var = "SELECT field FROM table "; $var .= "WHERE `field` = 'blub'";
so he could just copy & paste it to the code? Especially now that table_qbe is starting to be intelligent enough to come up with nice SQL it would make things easier for all those who develop in php (surely most of the users), but also other languages might be able to use it (c, perl etc. do have a rather similar syntax so it should be fine with them)
-- Gruß
Mike
Mike,
can we relate this to feature request 535227?
And where would this feature be located? Everytime PMA redisplays a query?
"Beck, Mike" a écrit :
just one idea: PMA always shows the SQL it created, so couldn't we just add a small checkbox and a textinput giving the user the possibility to add a variablename and then to have a second output of the SQL in the form of
$var = "SELECT field FROM table "; $var .= "WHERE `field` = 'blub'";
so he could just copy & paste it to the code? Especially now that table_qbe is starting to be intelligent enough to come up with nice SQL it would make things easier for all those who develop in php (surely most of the users), but also other languages might be able to use it (c, perl etc. do have a rather similar syntax so it should be fine with them)
-- Gruß
Mike
-
Beck, Mike -
Marc Delisle