SQL Update Command

Google Advertisements

Delete Command in SQL Constraints in SQL

SQL Update Command

Update command is used for modify the data in the table. Using this command you can modify all the records in the table and also you can modify some specific records in the table using "where clause". Using this command you can modify single column and also modify more than one column at a time.

Syntax

	
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE column_name=some_value;

Update column using where clause

Using where clause you can update specific record from any existing table.

Employee table

emp_idnamesalary
101Amit24000
104Gaurav26000
105Hitesh35000
102Rahul34000
103Sultan54000

Example

	
UPDATE Employee 
SET salary=100000,
WHERE emp_id=101;
);

Result after execute above query.

emp_idnamesalary
101Amit100000
104Gaurav26000
105Hitesh35000
102Rahul34000
103Sultan54000

Delete Command in SQL Constraints in SQL

Google Advertisements

Buy This Ad Space @$50 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Cloud computing is the on demand availability of computer system resources, especially data storage and computing power, without direct active management by the user. Cloud Computing Tutorial

College Projects Related to Java, AWT, C Projects for College, C++ Projects for College, Android Projects. Download Java C C++ Projects

Download Projects

Adsense Advertisements


Buy This ads Space 8076671483

Buy This Ad Space @$120 per Month, Ad Size 300X600 Contact on: hitesh.xc@gmail.com or 8076671483 Try this Keyword C++ Programs