>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
as a wildcard.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Cc: "Octavian Rasnita" <[EMAIL PROTECTED]>
Sent: Fr
t; <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Cc: "Octavian Rasnita" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 8:31 PM
Subject: Re: Column names
On 17 Jan 2003, at 16:40, Octavian Rasnita wrote:
> In MySQL I know that I need to put the colu
On 17 Jan 2003, at 16:40, Octavian Rasnita wrote:
> In MySQL I know that I need to put the column names between `` in some
> cases if they contain a % or an _ sign in it. Please tell me what sign
> can I use to link 2 words in a column without needing to include that
> column name between ``.
>
>
Are you creating new tables or importing from an old application? If you
are building something from scratch it is a really really bad idea to use
spaces in the names or start putting in special characters, you're just
making more work for yourself, and anyone that works on the application
after y
In the last episode (May 31), David Adam said:
> I have a table that includes numerous column names of the form
> '%_Dry_Weight' -- that is, they start with a
> percent sign. I am unable to query these columns, as mysql returns a
> "you have an error in your SQL syntax'
> message. When I try to
At 0:06 -0600 3/31/02, Alex Behrens wrote:
>Hey Guys,
>
>What is the command to display the names of all the columns in a table?
SHOW COLUMNS FROM tbl_name;
DESCRIBE tbl_name;
EXPLAIN tbl_name;
They're described in the manual.
>
>-mysql
>Thanks!
>
>-A
What would
SELECT 42 FROM SOME_TABLE
return? column name 42 or the numerical value 42 ?
M
-Original Message-
From: Sparta Cruz [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 08:23
To: MySQL
Subject: Column Names
MySQL's Documentation:
A name may start with any character that i