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)Moderator: General Moderators
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)Code: Select all
INSERT INTO article_assignment(article_assignment.article_id, article_assignment.category_id) SELECT articles.article_id, articles.article_category FROM articles WHERE articles.article_id>14