MariaDB - 更新数据(Update)

UPDATE table_name SET field=new_value, field2=new_value2,...
[WHERE ...]

UPDATE table
SET column1 = expression1,
    column2 = expression2,
    ...
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]]
[LIMIT number_rows]; 

UPDATE Students
SET student_name = 'Aryan'
WHERE student_name = 'Ajeet'; 

UPDATE Students
SET student_name = 'Maria',
 student_address = 'Goa'
WHERE student_name = 'Alecia'; 

SELECT * FROM Students;