[UPHPU] SQL field as prefix for all fields

Dave Smith 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.

--Dave


More information about the UPHPU mailing list