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

[Marc Delisle]

Chirayu Chiripal a écrit :
> On Fri, May 23, 2014 at 12:35 AM, Marc Delisle <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)