sql to copy from one table to another
Posted: Mon Aug 23, 2004 8:16 pm
I'm trying to get two columns from one table (articles) to copy into two columns of a second table (article_assignment). I keep getting a mysql error indicating a syntax error near VALUES.
Does anybody know where I've gone astray?
Does anybody know where I've gone astray?
Code: Select all
INSERT INTO article_assignment(article_id, category_id) SELECT article_id, article_category FROM articles VALUES (articles.article_id, articles.article_category)