List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:April 18 2005 11:07pm
Subject:Re: Warning (reformulated)
View as plain text  
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
> 
> Realizing maybe my first post wasn't clear enough...
> 
> How can I determine the cause for a warning.
> 
> The MySql version is 3.23.58
> 
> The query I used was:
> 
> UPDATE `shop_products` SET
> `name`='TestProd' ,
> `shopid`='20-302' ,
> `sdesc`='This is a test product' ,
> `ldesc`='Long description for the test product\r\n\r\nIt supports formatting but not
> objectss\r\n\r\n' ,
> `unit`='piece' ,
> `units`='pieces' ,
> `stock`='10' ,
> `unitprice`='20.00000' ,
> `tax`='0' ,
> `min_units`='1' ,
> `max_units`='' ,
> `delivery_inc_unitprice`='0.00000' ,
> `delivery_tax`='0' ,
> `delivery_time`='' ,
> `visible`='1' ,
> `active`=''
> WHERE `id`='1' LIMIT 1;
> 
> Thank you all
> 
> With kind regards
> 
> Andy
> 
> --
> 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------
> 
> Check out these few php utilities that I released
>  under the GPL2 and that are meant for use with a
>  php cli binary:
> 
>  http://www.vlaamse-kern.com/sas/
> --
> 
> --
> 
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
Warning (reformulated)Andy Pieters15 Apr
  • Re: Warning (reformulated)Eric Bergen19 Apr