Hi Tanner,
Tanner Postert wrote:
i'm using the following query:
REPLACE INTO vviews_total(
SELECT uuser_id, sum( vviews.views ) AS views, sum( vviews.embeds ) AS
embeds, sum( vviews.plinks ) AS plinks, sum( vviews.`30d` ) AS 30d, sum(
vviews.`7d` ) AS 7d, sum( vviews.`24h` ) AS 24h, sum( vviews.site30d ) AS
site30d, sum( site7d ) AS site7d, sum( vviews.site24h ) AS site24h, sum(
vviews.click ) AS click, now( ) AS last_dt
FROM vviews
JOIN video ON ( video.id = vviews.video_id )
WHERE video.nsfw =0
GROUP BY vviews.uuser_id )
the query works fine. it grabs the SUM for each of the fields and sums them
to insert into the other table, but when i try to run the above query.. .i
get an errors
FUNCTION db.sum does not exist.
I think the syntax you want is
REPLACE INTO tbl (col, col, ... col) SELECT...
Not
REPLACE INTO tbl(SELECT)
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]