From: Eric Bergen
Date: April 18 2005 11:07pm
Subject: Re: Warning (reformulated)
List-Archive: http://lists.mysql.com/mysql/182814
Message-Id: <11b1bd9905041816076e5cf73c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Warnings are usually caused by type mismatches in what you try to put
in a column vs what it will actually hold. For example putting a
'asdf' in a char(3) will produce a warning because 'asdf' was
truncated to 'asd' Check your column types vs the data you tried to
insert.

-Eric

On 4/15/05, Andy Pieters <andy@stripped> wrote:
> Hi all
>=20
> Realizing maybe my first post wasn't clear enough...
>=20
> How can I determine the cause for a warning.
>=20
> The MySql version is 3.23.58
>=20
> The query I used was:
>=20
> UPDATE `shop_products` SET
> `name`=3D'TestProd' ,
> `shopid`=3D'20-302' ,
> `sdesc`=3D'This is a test product' ,
> `ldesc`=3D'Long description for the test product\r\n\r\nIt supports forma=
tting but not objectss\r\n\r\n' ,
> `unit`=3D'piece' ,
> `units`=3D'pieces' ,
> `stock`=3D'10' ,
> `unitprice`=3D'20.00000' ,
> `tax`=3D'0' ,
> `min_units`=3D'1' ,
> `max_units`=3D'' ,
> `delivery_inc_unitprice`=3D'0.00000' ,
> `delivery_tax`=3D'0' ,
> `delivery_time`=3D'' ,
> `visible`=3D'1' ,
> `active`=3D''
> WHERE `id`=3D'1' LIMIT 1;
>=20
> Thank you all
>=20
> With kind regards
>=20
> Andy
>=20
> --
> Registered Linux User Number 379093
> -- ---BEGIN GEEK CODE BLOCK-----
> Version: 3.12
> GAT/O/CM d- s:+ a- C++++ UL++++ P+ L+++ E--- W+++ N++ o+ K w--- O+++ M- V
> PS+ PE++ Y+ PGP+++ t+ 5-- X R !tv b DI+++ D++ G e-- h+ r--- y+
> -- ---END GEEK CODE BLOCK------
>=20
> Check out these few php utilities that I released
>  under the GPL2 and that are meant for use with a
>  php cli binary:
>=20
>  http://www.vlaamse-kern.com/sas/
> --
>=20
> --
>=20
>=20
>=20


--=20
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net