Garth Webb wrote:
I'm not asking for an alternative way to do it; I'm asking what
is wrong with what I did?
It looks like you want to copy over several or all values from a second
table. The INSERT .. SELECT syntax isn't an alternate way, its the only
way.
Okay, thanks for the clarification. I didn't register what they
were talking about with the INSERT ... SET form, I guess I was assuming
othertable.othercolumn was an "explicit value" as per that sentence,
but combined with the next sentence I see they mean constant values
and certainly no references to another table.
Darn, I ws hoping there was some form that allowed the juxtaposition of
old and new closer to each other.
thanks,
-Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
