Re: MySQL Feature

2003-02-13 Thread Zak Greant
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

RE: MySQL Feature

2003-02-13 Thread Luc Foisy
-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

Re: MySQL Feature

2003-02-13 Thread Zak Greant
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

Re: MySql Feature

2002-12-07 Thread Benjamin Pflugmann
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

Re: MySql Feature

2002-12-07 Thread Michael She
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

Re: MySql Feature

2002-12-07 Thread Stefan Hinz, iConnect \(Berlin\)
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

Re: MYSQL Feature :)

2001-03-01 Thread Sinisa Milivojevic
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