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

[Chirayu Chiripal]

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

-- 
Regards,
Chirayu Chiripal
phpMyAdmin Intern - Google Summer of Code 2014
https://chirayuchiripal.wordpress.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140523/b326a128/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sql_export.png
Type: image/png
Size: 83992 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140523/b326a128/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: QA_4_2_Button_1_export.sql
Type: text/x-sql
Size: 3156 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140523/b326a128/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: QA_4_2_Button_2_export.sql
Type: text/x-sql
Size: 2207 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140523/b326a128/attachment-0001.bin>