How to use the update command in MySQL

Update command-  

  • To update the department & mobile no of suneel

Query-
update employee set Department= ‘IT’, salary= ‘15000’ where Emp_ID= 5775

Update Table

update user_leave_balance set cl_balance= ’20’ where Emp_id=’005969′; 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s