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[2]: MySQL Feature

2003-02-13 Thread Stefan Hinz
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 Tabl

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

MySQL Feature

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

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

MySql Feature

2002-12-06 Thread Johan
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 m

Re[2]: MYSQL Feature :)

2001-03-01 Thread Peter Zaitsev
Hello Sinisa, Thursday, March 01, 2001, 3:42:46 PM, you wrote: SM> > I'm not really shure if this is a bug or correct behavior, but still SM> > it leads to toe problems in this case: SM> > SM> > insert into g02layers_stat_hits set counter=1, type=1, page_group=1; SM> > ERROR 1062: Duplicat

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

MYSQL Feature :)

2001-02-28 Thread Peter Zaitsev
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 to toe problems in this case: insert int