MySQL insert query error

Question

Whats wrong with this query. I'm getting an error saying

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Item 1') where ItemName like 'Item 1' at line 1

My query is

insert into newitem (QuantityAvailable) values 
(Select count(*) from  addtoinventory where ItemName like 'Item 1') 
where ItemName like 'Item 1'

the first where clause is for the nested query. I'm counting all those rows with item name like "Item 1" and the second where clause is for the insert where I'm inserting into those rows (the output of nested query) where Item name like "Item 1" — Ank
– Ank, Commented Jan 1, 2012 at 22:34

Gary · Accepted Answer · 2012-01-01 22:37:26Z

3

Take out the word values from your query.

Also, I don't see what you expect the where clause to do in the outer query. If you haven't inserted a value yet, how can you compare it to anything? If you have, then the inner where clause takes care of that.

answered Jan 1, 2012 at 22:37

Gary

785 bronze badges

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

1 Comment

Ank Over a year ago

I'm so sorry for asking this stupid question. I am still in a party mood.. I should use update newitem rather than insert into .. !!

demo.b · Accepted Answer · 2012-01-01 22:43:59Z

0

insert into newitem (QuantityAvailable) Select count(*) from addtoinventory where ItemName like '%Item 1%'

answered Jan 1, 2012 at 22:43

demo.b

3,4572 gold badges31 silver badges31 bronze badges

Collectives™ on Stack Overflow

MySQL insert query error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related