>is it possible to suppress (i.e. not display) the column names
>from the resultset of a select statement? if so, how?
What about only selecting the columns you need?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Producti
"Tom Roos" <[EMAIL PROTECTED]> wrote:
> is it possible to suppress (i.e. not display) the column names from the resultset of
> a
> select statement? if so, how?
For command-line mysql client use --skip-column-names (-N) option:
http://dev.mysql.com/doc/mysql/en/mysql.html
--
For techn
'lo
is it possible to suppress (i.e. not display) the column names from the resultset of a
select statement? if so, how?
tks
tom
Disclaimer
http://www.shoprite.co.za/disclaimer.html
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
"James E Hicks III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Isn't there a way to prefix (or postfix) a tables column names in the
results
> of a select. For example I have a table named from_address. This t
Isn't there a way to prefix (or postfix) a tables column names in the results
of a select. For example I have a table named from_address. This table has
the column names line1,line2,line3,line4,line5. When I do a select query on
from_address I want all columns to return as from_line1, from_line2