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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
