[UPHPU] SQL field as prefix for all fields
dave at thesmithfam.org
Mon Jan 28 16:22:48 MST 2008
Scott Hill wrote:
> with renaming all of the columns in the SQL statement. If you are using
> Postgres or something besides MySQL you might do something like this in a
> stored procedure although I have never tried it. It would be neat if
> someone could figure out a nifty way to do this.
Are you using a version of MySQL that supports Views? If so, just make a
View that has the column names the way you want, and then SELECT from
the View instead of directly from the table.
More information about the UPHPU