MySQL UPDATE Query

[ANDERS]

I want information about update Query in My SQL As i want to change name of Student from Student table. I tried to run queries but it didn't work can some one help me ?

Thanks

[Samir_1]

You modify table by using SQL UPDATE command. This will modify any field value of any MySQL table. Here is generic SQL syntax of UPDATE command to modify data into MySQL table:

UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]

[Japesh]

Updating Data from Command Prompt:

This will use SQL UPDATE command with WHERE clause to update selected data into MySQL table.

UPDATE Student
SET Student _name='XYX'
WHERE Student_id=3