[Phpmyadmin-devel] always include db and table names in generated querys

Hi, while working on bug #1431615 'Exporting specific rows from query with join' i wonder if it would be wise to always include db and table names in references used in queries generated by phpMyAdmin? i think it does no harm to add this, and it is more secure as it is absolutely sure what column is meant by this query, especially with delete queries - if ever in error a wrong database is selected before delete query is executed. -- Sebastian

Sebastian Mendel a écrit :
Hi,
while working on bug #1431615 'Exporting specific rows from query with join'
i wonder if it would be wise to always include db and table names in references used in queries generated by phpMyAdmin?
I agree.
i think it does no harm to add this, and it is more secure as it is absolutely sure what column is meant by this query, especially with delete queries - if ever in error a wrong database is selected before delete query is executed.

Hi On Sun, 19 Feb 2006 09:50:26 +0100 Sebastian Mendel <lists@sebastianmendel.de> wrote:
while working on bug #1431615 'Exporting specific rows from query with join'
i wonder if it would be wise to always include db and table names in references used in queries generated by phpMyAdmin?
i think it does no harm to add this, and it is more secure as it is absolutely sure what column is meant by this query, especially with delete queries - if ever in error a wrong database is selected before delete query is executed.
You're right for internal queries. This can not be applied to export. -- Michal Čihař | http://cihar.com
participants (3)
-
Marc Delisle
-
Michal Čihař
-
Sebastian Mendel