On Fri, May 23, 2014 at 12:35 AM, Marc Delisle marc@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.