mysql> update subject_name_name set name_name='Ciencias atmosféricas' where subjectid='A' and pos='2';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update subject_name_name set name_name='Gestión de la información' where subjectid='P' and pos='2';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select subjectid, pos, name_name from subject_name_name where subjectid='A' or subjectid='P';
+-----------+-----+---------------------------+
| subjectid | pos | name_name |
+-----------+-----+---------------------------+
| A | 0 | Atmospheric Sciences |
| A | 1 | Atmospheric Sciences |
| A | 2 | Ciencias atmosféricas |
| P | 0 | Information Management |
| P | 1 | Information Management |
| P | 2 | Gestión de la información |
+-----------+-----+---------------------------+
Monday, May 24, 2010
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment