Monday, May 24, 2010

AquaComm subject translation

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 |
+-----------+-----+---------------------------+

0 comments: