column alias on mass

[sks]

Hi all,

Is possible to retrieve all columns and alias them all at once. Eg, normally
you would write

select * from products which would return

id | name | price
-----------------------
1 | Test | 14.00

but I want to be able to say

select p.* from products p, so that it returns the columns as such

p.id | p.name | p.price

Obviously I can do this manually as such

select p.id, p.name, p.price from products p ....

But that would take a lot of big queries as some of my tables have 50
columns.

[Bill Karwin]

sks wrote:

but I want to be able to say

select p.* from products p, so that it returns the columns as such

p.id | p.name | p.price

Obviously I can do this manually as such

select p.id, p.name, p.price from products p ....

Actually, that would return

id | name | price

The column labels don't implicitly include the table alias dot notation.
You'd have to do a query like this:

select p.id as `p.id`, p.name as `p.name`, p.price as `p.price` from
products p ....

It's good to get in the habit of using the backquotes, because then you
can use special characters or even whitespace in your column labels.

There is no syntax to declare the column labels automatically. You have
to specify all of them individually.

Regards,
Bill K.

[sks]

"Bill Karwin" <bi**@karwin.com> wrote in message
news:e3*********@enews4.newsguy.com...

sks wrote:

but I want to be able to say

select p.* from products p, so that it returns the columns as such

p.id | p.name | p.price

Obviously I can do this manually as such

select p.id, p.name, p.price from products p ....

Actually, that would return

id | name | price

The column labels don't implicitly include the table alias dot notation.
You'd have to do a query like this:

select p.id as `p.id`, p.name as `p.name`, p.price as `p.price` from
products p ....

It's good to get in the habit of using the backquotes, because then you
can use special characters or even whitespace in your column labels.

There is no syntax to declare the column labels automatically. You have
to specify all of them individually.

Ok thanks for replying.