How to setup mysql on Linux

17. To select a field based on certain parameters:

mysql> SELECT Name FROM student WHERE age > 30;

18. To update a field in a table:

mysql> UPDATE student SET Name="Atul" where age=31;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>

In below entry for Atul name got updated.