...
Code Block |
---|
|
update country set country = 'Democratic Republic of Congo'
where country_id = 461;
commit; |
Finally, fix any incorrect entries in the actual NODEDETAILS table by putting the correct country in the set clause and the incorrect value in the where clause.
Code Block |
---|
|
update nodedetails set country = 'Democratic Republic of Congo'
where country = 'Democratic Repulic of Congo';
commit; |
To re-assign a country from one region to another, change the CONTINENT value in both tables.
Code Block |
---|
|
update country set continent = 'Europe' where country = 'Latvia';
update nodedetails set continent = 'Europe' where country = 'Latvia';
commit; |
Problems
The checking the validity of the data is not particularly robust, especially when creating a new entry. It can complain that there is an error in the data (invalid IPv4 address, extra spaces in the field, duplicate nodename (i.e. it already exists)). The error messages are not very instructive. In this case, you may be able to correct the entry or you may have to cancel the entry and re-create it.
...