MySQL UPDATE Statement

MySQL UPDATE Statement:

The primary statement used to modify the existing data in a MySQL database is an UPDATE statement. The UPDATE statement allows you to modify one or more fields for one or more records in a table. Here the basic syntax for the UPDATE statement is:

UPDATE table_name
SET field1 = new_value1,
field2 = new_value2 [WHERE Clause]

Sample Table:

MySQL UPDATE Statement Sample Table

Example 1: UPDATE Statement Used on the age column.

mysql update statement example to change age

Example 2: UPDATE Statement Used on the name column.

MySQL UPDATE Statement example to change name

Computer Network
Wired Networking
Wireless Networking
Multimedia and Its Application
World Wide Web (WWW)
FTP (File Transfer Protocol)
MySQL– Wikipedia

Comments (No)

Leave a Reply