From: lamjoun [mailto:lamjoun@stripped]
> Hi,
> I have a problem with this request.
>
> insert into table month_var (year,month,var_cd,val) select
> '2003','10',var_cd,0 from var and
> var_cd not in (select var_cd from month_var where year='2003' and
> month='10');
> thanks
This isn't a "problem request" to "be resolved in the next versions." You're simply using
incorrect MySQL syntax.
Since you've now posted this three times with no further explanation of what you're trying
to get at, one can only assume you're trying to perform an INSERT INTO...SELECT FROM
that'd be helped by using a join of some sort.
If you're trying to limit it based on values found or not found in another table, as it
appears, try something like...
INSERT INTO month_var (year, month, var_cd, val)
SELECT '2003', '10', var.var_cd, '0' FROM var
LEFT JOIN month_var ON month_var.var_cd=var.var_cd
WHERE month_var.year='2003'
AND month_var.month='10'
AND month_var.var_cd IS NULL
I don't have your table structure and, actually, am not entirely sure of what you're
aiming for, so I don't know if that above query works. If not, try looking at the manual.
INSERT...SELECT syntax
http://www.mysql.com/doc/en/INSERT_SELECT.html
JOIN syntax
http://www.mysql.com/doc/en/JOIN.html
--
Mike Johnson
Web Developer/Systems Asst.
Smarter Living, Inc.
phone (617) 497-2500 x226
