error 1046 in subquery inserting data from specific columns to another table [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 7 months ago.

Improve this question

I am trying to copy a few fields of video information from one MariaDB table to another using a subquery, decoupling some video info from a classified ads table for later refactoring.

video:

id (int 11 autoincrement)
video_source (varchar 50)
video_url (varchar 255)
user_id(int 11)

I copy two fields:

INSERT INTO videos (video_url,user_id)
VALUES (SELECT youtube_url as video_url, user_id
    FROM ads WHERE ads.youtube_url!="")

The subquery works on its own, but the insert query gives me an error 1046 and the cryptic message that I have an error in my subquery.

What are issues with the auto increment field in the video table?

What is wrong with my query?

Ask 1 specific researched non-duplicate question. Debug questions require a minimal reproducible example. The question will clearly be a faq that is not usefully asked yet another time. — philipxy
– philipxy, Commented Apr 27 at 18:27
Please before considering posting read the manual/reference & google any error message & many clear, concise & precise phrasings of your question/problem/goal, with & without your particular names/strings/numbers, 'site:stackoverflow.com' & tags; read many answers. How much research effort is expected of Stack Overflow users? How to Ask Help center Reflect research in posts. Please in code questions give a minimal reproducible example. — philipxy
– philipxy, Commented Apr 27 at 18:27

philipxy · Accepted Answer · 2025-04-27 18:12:18Z

1

Use the proper version of INSERT:

INSERT INTO videos (video_url,user_id) 
  SELECT youtube_url, user_id 
     FROM ads WHERE youtube_url!='';

edited Apr 27 at 18:12

philipxy

15.2k6 gold badges44 silver badges101 bronze badges

answered Apr 27 at 17:57

Sergey

5,2801 gold badge9 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

philipxy Apr 27 at 18:30

Whatever 1 question this post is trying to ask is clearly a trivially found faq that is not usefully asked or answered yet another time.

Palm Boom Apr 28 at 16:46

Apologies for all the commotion apparently, this is my first stack overflow post, thank you philipxy for providing me with the solution.

Collectives™ on Stack Overflow

error 1046 in subquery inserting data from specific columns to another table [closed]

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related