dan orlic wrote:
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now() as created, now() as last_modified FROM copperlamp.Items g order
by g.RecordID asc;
and it does not error out, but there are problems with this... for
example:
... g.Desc4 as price ... g.Desc4 ($500.00) is a varchar and price is a
BigDecimal(10.2). but when it gets inserted the value is 0.00 for
every field.... that's one the other is:
...g.Item + g.Desc1 + g.Desc2 + g.Desc3 as description ... but though
they are all varchars i can't seem to incorporate all the values into
that one field. any thoughts would be great.
dan
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]