Unable to insert

Database
Enthusiast

Unable to insert

Hi

I am trying to insert data in a particular column but its not working


insert into emp(hire_date)

values(2009-03-18)

where eno= 2

Thanks,

Rohit

2 REPLIES
Senior Apprentice

Re: Unable to insert

Hi Rohit,

Insert adds new rows, but this looks like you want to update an existing row:

update emp
set hire_date = date '2009-03-18'
where eno= 2
Enthusiast

Re: Unable to insert

Thanks Dieter