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 'Somethi

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'

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

2002-12-07 Thread Stefan Hinz, iConnect \(Berlin\)
. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Michael She" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[EMAIL PROTECTED]> Cc: "Johan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&g

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 > - V

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 http://www.mysql.com/doc/e

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 > i