Consulta UPDATE

[huesos52]

Con este ejemplo te queda claro?

Código MySQL:

mysql> select *from paises;
+---------+------------+
| codpais | nombrepais |
+---------+------------+
|       7 | colombia   |
|       8 | venezuela  |
+---------+------------+
2 rows in set (0.00 sec)
 
mysql> SELECT *FROM paises;
+---------+------------+
| codpais | nombrepais |
+---------+------------+
|       7 | colombia   |
|       8 | venezuela  |
+---------+------------+
2 rows in set (0.00 sec)
 
mysql> UPDATE paises SET nombrepais='mexico' WHERE codpais=7;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> SELECT *FROM paises;
+---------+------------+
| codpais | nombrepais |
+---------+------------+
|       7 | mexico     |
|       8 | venezuela  |
+---------+------------+
2 rows in set (0.00 sec)