SQL Basic- SQL UPDATE Command ~ Beginner School

SQL UPDATE

This statement is used to update records in a table.

SQL UPDATE Statement

The SQL update statement is used to update existing record in a table.

Syntax:

[To update the existing record into the table, we are using SQL UPDATE command as follows:]

UPDATE table_name

SET col1=value1, col2=value2

WHERE column=value;

Note:

WHERE clause:

In SQL UPDATE Statement, WHERE clause specifies which record should be updated.

If you don't use WHERE clause,then SQL UPDATE condition update all records.

Data Is Updated Only in Specified Columns:

The following statement will update existing record as per the specifies condition in WHERE Clause.

Below is existing "Student" table:

Example 1:

[we update existing student "Ajeet" with a new Address in "Student" table.]

The following statement are used as to Update a existing "Ajeet's " record into the "Student" table:

UPDATE Student

SET Address='Delhi'

WHERE StudentName='Ajeet';

Result:

Message Comes: (1 row(s) affected)

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Beginner School