[Phpmyadmin-devel] RFE #759 use aliases in SQL export for tables and columns

[Marc Delisle]

Le 2014-05-24 14:52, Chirayu Chiripal a écrit :
> Hi,
> 
> On Fri, May 23, 2014 at 12:52 AM, Marc Delisle <marc at infomarc.info
> <mailto:marc at infomarc.info>> wrote:
> 
>     Chirayu Chiripal a écrit :
>     > On Fri, May 23, 2014 at 12:35 AM, Marc Delisle <marc at infomarc.info
>     <mailto:marc at infomarc.info>> wrote:
>     >
>     >> Chirayu Chiripal a écrit :
>     >>> Hi,
>     >>>
>     >>> While analyzing the current behavior of export feature, few
>     doubts has
>     >>> arisen in my mind regarding it. In sql_export.png, There are two
>     export
>     >>> buttons, button 1 & button 2 respectively. When exporting using
>     Button 1
>     >>> shown in sql_export.png, the resulting sql file had all the rows (20
>     >> rows)
>     >>> present in the table (See QA_4_2_Button_1_export.sql) whereas when
>     >> Button 2
>     >>> was used then only the rows (10 rows) displayed in results
>     according to
>     >> the
>     >>> LIMIT condition in the query were in the sql file (See
>     >>> QA_4_2_Button_2_export.sql). Is this the correct behavior or
>     both should
>     >>> have generated identical sql export file?
>     >>>
>     >>> SQL query which was used: SELECT * FROM `abcd` WHERE 1 limit 10
>     >>>
>     >> Button 1 means to export the rows that you have selected via each
>     row's
>     >> checkbox.
>     >>
>     >> --
>     >> Marc Delisle (phpMyAdmin)
>     >>
>     >
>     > What if I didn't selected any rows?
>     >
>     > IMHO, In this case it should not export rows which are not in the
>     resultset
>     > of the query but it is exporting all the rows of the table.
> 
>     Correct, it should not export anything.
> 
>     --
>     Marc Delisle (phpMyAdmin)
>      
> 
>  
> Currently, there is no SQL Export for queries involving multiple tables
> such as join query. So, does that mean aliases is to be considered only
> in SELECT statements involving one table? or Am I missing something here?

Indeed, exporting a join query makes no sense to me.


-- 
Marc Delisle | phpMyAdmin