Web development lesson 46 php mysql update query example

#pashto #update_data
updating data in database tables
A database table's existing records can be altered or modified using the UPDATE statement. This phrase is frequently used in conjunction with the WHERE clause to limit the records to which the changes will be applied.

The UPDATE statement's fundamental syntax is as follows:

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

Let's create a SQL query that uses the WHERE clause and UPDATE statement, then we'll execute it by providing it to the PHP mysqli query() function to update the records in the tables. Think about the people table in the demonstration database: