On Apr 20, 2009, at 10:34 PM, Matthew Pugsley wrote:
I've solved it.
I just used a subselect. Worked very quickly. I had a lot of trouble
with subqueries when I first started databases with MySQL. So I have
been afraid of them.
update entities
set customer_status = select(customer_status
I've solved it.
I just used a subselect. Worked very quickly. I had a lot of trouble with
subqueries when I first started databases with MySQL. So I have been afraid
of them.
update entities
set customer_status = select(customer_status from entity_dimension_update
where entities.entity_id = entit
Hello,
I am looking for a way to update one table with another. I tried the
following schema to update table2 based on data in table1. The idea is that
I have a slowly changing dimension and I need to update data in the
dimension based on an updated version of the table. I don't want to have to
dr
