Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 6:40 PM, Victor Subervi wrote: > > I'm lost. I set up this database originally with auto_increment and the > first value was 0. I thought that was always the case. Is there a problem > here? > Yes, that should not have happened. For autoincrement fields, both NULL and 0 ar

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 8:43 AM, Johan De Meersman wrote: > On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge > wrote: > > > Jørn Dahl-Stamnes wrote: > > > >> On Friday 11 December 2009 10:38, Victor Subervi wrote: > >> > >>> Hi; > >>> > >>> mysql> update products set sizes="('Small', 'Large')" where

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge wrote: > Jørn Dahl-Stamnes wrote: > >> On Friday 11 December 2009 10:38, Victor Subervi wrote: >> >>> Hi; >>> >>> mysql> update products set sizes="('Small', 'Large')" where ID=0; >>> Query OK, 0 rows affected, 1 warning (0.00 sec) >>> Rows matched: 1

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 5:33 AM, wrote: > > On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi > > wrote: > > On Fri, Dec 11, 2009 at 5:13 AM, wrote: > > > >> > >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi > >> > >> wrote: > >> > >> > mysql> update products set sizes="('Small', 'Large

Re: Update Doesn't Update!

On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi wrote: > On Fri, Dec 11, 2009 at 5:13 AM, wrote: > >> >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi >> >> wrote: >> >> > mysql> update products set sizes="('Small', 'Large')" where >> SKU='prodSKU1'; >> > Query OK, 0 rows a

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 5:13 AM, wrote: > > On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi > > wrote: > > > mysql> update products set sizes="('Small', 'Large')" where > SKU='prodSKU1'; > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Rows matched: 1 Changed: 0 Warnings: 1 > > > > m

Re: Update Doesn't Update!

Quoting cars...@bitbybit.dk: Of course you can have ID=0. Definately agree mysql> DESCRIBE test; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---

Re: Update Doesn't Update!

day, December 11, 2009 6:13 PM Subject: Re: Update Doesn't Update! > > On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi > > wrote: > >> mysql> update products set sizes="('Small', 'Large')" where > SKU='prodSKU1'; >> Qu

Re: Update Doesn't Update!

Jørn Dahl-Stamnes wrote: On Friday 11 December 2009 10:38, Victor Subervi wrote: Hi; mysql> update products set sizes="('Small', 'Large')" where ID=0; Query OK, 0 rows affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 Look at the

Re: Update Doesn't Update!

On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi wrote: > mysql> update products set sizes="('Small', 'Large')" where SKU='prodSKU1'; > Query OK, 0 rows affected, 1 warning (0.00 sec) > Rows matched: 1 Changed: 0 Warnings: 1 > > mysql> show warnings; > +-+--+--

Re: Update Doesn't Update!

On Fri, 11 Dec 2009 10:48:59 +0100, Jørn Dahl-Stamnes wrote: > On Friday 11 December 2009 10:38, Victor Subervi wrote: >> Hi; >> >> mysql> update products set sizes="('Small', 'Large')" where ID=0; >> Query OK, 0 rows affected, 1 warning (0.00 sec) >> Rows matched: 1 Changed: 0 Warnings:

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 4:43 AM, wrote: > > On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi > > wrote: > > Hi; > > > > mysql> update products set sizes="('Small', 'Large')" where ID=0; > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Rows matched: 1 Changed: 0 Warnings: 1 > > "Warnin

RE: Update Doesn't Update!

[mailto:victorsube...@gmail.com] Sent: 11 December 2009 10:06 Cc: mysql@lists.mysql.com Subject: Re: Update Doesn't Update! On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes wrote: > On Friday 11 December 2009 10:38, Victor Subervi wrote: > > Hi; > > > > mysql> updat

Re: Update Doesn't Update!

mysql> update products set sizes="('Small', 'Large')" where ID=0; Query OK, 0 rows affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 Look at the message, 0 rows changed and 1 warning. You cannot have ID=0 if ID is an index. Are you

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes wrote: > On Friday 11 December 2009 10:38, Victor Subervi wrote: > > Hi; > > > > mysql> update products set sizes="('Small', 'Large')" where ID=0; > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Rows matched: 1 Changed: 0 Warnings: 1 >

Re: Update Doesn't Update!

On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes wrote: > On Friday 11 December 2009 10:38, Victor Subervi wrote: > > Hi; > > > > mysql> update products set sizes="('Small', 'Large')" where ID=0; > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > Rows matched: 1 Changed: 0 Warnings: 1 >

Re: Update Doesn't Update!

On Friday 11 December 2009 10:38, Victor Subervi wrote: > Hi; > > mysql> update products set sizes="('Small', 'Large')" where ID=0; > Query OK, 0 rows affected, 1 warning (0.00 sec) > Rows matched: 1 Changed: 0 Warnings: 1 Look at the message, 0 rows cha

Re: Update Doesn't Update!

On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi wrote: > Hi; > > mysql> update products set sizes="('Small', 'Large')" where ID=0; > Query OK, 0 rows affected, 1 warning (0.00 sec) > Rows matched: 1 Changed: 0 Warnings: 1 "Warnings: 1" do a SHOW WARNINGS immediately after you e

Update Doesn't Update!

Hi; mysql> update products set sizes="('Small', 'Large')" where ID=0; Query OK, 0 rows affected, 1 warning (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 mysql> select sizes, colorsShadesNumbersShort from products where ID=0; +---+--+ | sizes | colorsShadesNumbers