I believe it would be...
UPDATE contributors,contributor_sort SET
contributors.namesort=contributor_sort.namesort
WHERE contributors.name=contributor_sort.name
--
Jim Wright
Wright Business Solutions
[EMAIL PROTECTED]
919-417-2257
off the top of my head, may have errors..
update contributors c
set c.namesort = ( select cs.namesort
from contributor_sort cs
where c.name = cs.name)
On 6/3/06, Jim McAtee <[EMAIL PROTECTED]> wrote:
> Using MySQL 5.0.21, I have two tables:
>
> contributors
> -
> contributor_id
>
Using MySQL 5.0.21, I have two tables:
contributors
-
contributor_id
name
namesort
contributor_sort
-
name
namesort
I'd like to update the namesort column in contributors by using the values
in the namesort column in contributor_sort wherever name = name. I don'
Marco Antonio C. Santos wrote:
> How can I do MySQL works fine with this simple query:
>
> SELECT DISTINCT User_ID,(SELECT Count(User_ID) FROM users p1 WHERE
> p1.User_ID = users.User_ID) AS CountID
> FROM users
SELECT User_ID, count(User_ID)
FROM users
GROUP BY User_ID
Jochem
[Todays Threads]
How can I do MySQL works fine with this simple query:
SELECT DISTINCT User_ID,(SELECT Count(User_ID) FROM users p1 WHERE
p1.User_ID = users.User_ID) AS CountID
FROM users
MySQL don't have subselect capabilities, so
We're using 4.0.12 version in Win2K3 server...
Thanx
[Todays Threads]
[Th
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 8:16 AM
To: CF-Talk
Subject: Re: mysql query help
You know, I've crafted two responses to this already (this is the third)
and both ended up being wrong after I thought about it for a while.
Someone else may be able to post the "r
You know, I've crafted two responses to this already (this is the third)
and both ended up being wrong after I thought about it for a while.
Someone else may be able to post the "right" solution, but in the
interim, you could
SELECT user, max(lineupid) as maxlineupid FROM tablename
group by us
Good morning,
I'm having a devil of a time with a mysql (v3.23) query and was hoping
someone here could give me a hand.
I have a fantasy football project I'm working on and I allow registered
users to pick a lineup every week and then I score them at the end of the
week depending on how well thei
8 matches
Mail list logo