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 technical
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
]
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 column names between `` in some
cases if they contain a % or an _ sign
: 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: Friday, January 17, 2003 8:31 PM
Subject: Re: Column names
On 17 Jan 2003, at 16:40, Octavian Rasnita wrote
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
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 ``.
Can
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!
-Alex Big
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