Unknown column name' in 'field list'

[Shinju15]

Hi everyone;

I am trying to update or inserting into a table depending of what is in the table. However, is gives me the error: Unknown column name' in 'field list'.

- Name is a column from the "Sold" table.
- I am trying to compare if that item is already in the table for the current month

If it is update sold table and increase the quantity of those items by one

else insert a new row in the table.​

SELECT *
FROM sold;
	
	IF name = v_ItemName AND time=DATE_FORMAT(NOW(), '%m') THEN
		UPDATE sold
		SET number_sold=number_sold + 1
		WHERE name =v_ItemName ;
	ELSE
		INSERT INTO sold
		(name, itemprice, quantity, time)
		VALUES
		(v_ItemName , v_itemprice, 1, DATEFORMAT(NOW(),'%m');
	END IF;

 

[ChrisHirst]

MySQL running on Linux is case sensitive so 'sold' and 'Sold' are not the same things.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum