MySQL query check

Question

what is wrong with this query?

INSERT INTO table1 VALUES id, pic0, pic1, pic2, pic3, pic4 FROM table2 WHERE condition1 = 'cond1' AND condition2 = 'cond2' AND age = '18' AND ( weight = '100 - 115 lbs' OR weight = '115- 130 lbs' ) AND hairlength <> 'short'

Conditions are for table2. I want to insert into table 1 just the rows from table two which meet the conditions set my me after WHERE clause.

Thank u

Tobiasopdenbrouw · Accepted Answer · 2010-08-12 12:41:16Z

2

I think you want:

INSERT INTO table1 (id, pic0, pic1, pic2, pic3, pic4)
SELECT id, pic0, pic1, pic2, pic3, pic4
FROM table2
WHERE condition1 = 'cond1' 
AND condition2 = 'cond2' AND age = '18' 
AND ( weight = '100 - 115 lbs' OR weight = '115- 130 lbs' )
AND hairlength <> 'short'

answered Aug 12, 2010 at 12:41

Tobiasopdenbrouw

14.1k1 gold badge24 silver badges28 bronze badges

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

2 Comments

Tobiasopdenbrouw Over a year ago

Sachin may also be correct: I don't know off the top of my head whether you need that VALUES statement in your query.

Sachin Shanbhag Over a year ago

actually you are right man. My query had VALUES in first line which will give syntax error. Now both our queries are same..;)

Sachin Shanbhag · Accepted Answer · 2010-08-12 12:40:55Z

0

try this -

INSERT INTO table1 (id, pic0, pic1, pic2, pic3, pic4)
select id, pic0, pic1, pic2, pic3, pic4  
FROM table2 WHERE condition1 = 'cond1' AND condition2 = 'cond2' 
AND age = '18' AND ( weight = '100 - 115 lbs' OR weight = '115- 130 lbs' ) 
AND hairlength <> 'short'

answered Aug 12, 2010 at 12:40

Sachin Shanbhag

55.7k11 gold badges92 silver badges103 bronze badges

Collectives™ on Stack Overflow

MySQL query check

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related