[ic] Replacing product group

Philip S. Hempel interchange-users@icdevgroup.org
Thu Aug 22 22:59:01 2002


Mike Heins wrote:
> 
> 
> yoursql> update products set prod_group = 'new_group'
>       -> where prod_group = 'old_group';
> 500 record(s) updated.
> 

Thanks for the "update", I was trying this with replace and getting
nowhere.

And for the statement of a small database, size does not
always effect the need for sql, since I also connect from
other systems to use this base to access.

I ran this query and it worked perfectly for me!
did another set of about 4 groups and in seconds
I was done!

Thanks for your support

-- 
	-------------------------
	    Philip S. Hempel
debian/rules