I want to use this- insert into sales(year1) values('344'); query to insert the value '344' into the column where the month column values in January.
However I cannot do so by using the WHERE CLAUSE like this:
insert into sales(year1) values('344') where Month='January';
This is the existing Table data:
'January', NULL, NULL
'Feb', NULL, NULL
NULL, '2000', NULL
NULL, '3000', NULL
NULL, '2000', NULL
P.S I want to insert the 344 value on top of the NULL near the 'January' value!