KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I've got two tables. Table_A (nid, vid, type, title, uid) Table_B (id, questiontext) I need to insert records from Table_B into Table_A. I tried this: INSERT INTO Table_A (nid, vid, type, title, uid) VALUES ('', '', multichoice', (SELECT questiontext from Table_B), '1') but it's throwing an error. What should be the correct statement? UPD: I should add that nid is autoincrement and the value of vid should be same as nid.
Tags (comma-separated)
Save Edits
Cancel