Difference between revisions of "SAHANA: Mendelete Wiki GIS yang salah entry data"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
use sahana; | use sahana; | ||
select * from gis_wiki; | select * from gis_wiki; | ||
| − | delete from gis_wiki where wiki_uuid=729ewm-12; | + | |
| + | Selanjutnya: | ||
| + | |||
| + | * Perhatikan kalau-kalau ada beberapa line / row yang kacau. | ||
| + | * Catat wiki_uuid dari line yang kacau tersebut | ||
| + | * Delete line tersebut menggunakan perintah: | ||
| + | |||
| + | delete from gis_wiki where wiki_uuid="729ewm-12"; | ||
Latest revision as of 08:30, 1 December 2009
Masuk ke shell di server
mysql -u sahana_sys -p password: use sahana; select * from gis_wiki;
Selanjutnya:
- Perhatikan kalau-kalau ada beberapa line / row yang kacau.
- Catat wiki_uuid dari line yang kacau tersebut
- Delete line tersebut menggunakan perintah:
delete from gis_wiki where wiki_uuid="729ewm-12";