I don't think it is possible at the moment, and pretty sure its not standard SQL but
it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
So in this example, if the expression was true, include that column in the result set,
otherwise
On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote:
I don't think it is possible at the moment, and pretty sure its not standard SQL but
it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
So in this example, if the
Luc, Zak,
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable
You can use a WHERE clause to get an effect like this.
SELECT CASE expression
WHEN 'value'
THEN column
...
ELSE 'default result'
END
FROM Table;
Or
-Original Message-
From: Zak Greant [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL Feature
On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote:
I don't think it is possible at the moment, and pretty sure
On Thu, Feb 13, 2003 at 02:10:18PM -0500, Luc Foisy wrote:
BUT
SELECT Data, CASE WHEN 0 != 0 THEN 'Something' END FROM table
will return two columns, Data and CASE WHEN 0 != 0 THEN 'Something' END. It
would be better if I could do..
SELECT Data, CASE WHEN 0 != 0 THEN 'Something' AS 'A
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver 4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
- Trigger
Please see
At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote:
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver
4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
PROTECTED]
To: Benjamin Pflugmann [EMAIL PROTECTED]
Cc: Johan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, December 07, 2002 8:22 PM
Subject: Re: MySql Feature
At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote:
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
Hello
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver 4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
- Trigger
2. How to use SSL ?
3. How to add a user that can login from any host ?
4. What are the differences between standard and
Peter Zaitsev writes:
Hello mysql,
Mysql 3.23.32 running on Linux.
I've got a table with auto_increment command stuck, well this is no
problem there is a record in this table with MAX_UINT value.
I'm not really shure if this is a bug or correct behavior, but still
it leads
10 matches
Mail list logo