Difference between revisions of "SAHANA: Mendelete Wiki GIS yang salah entry data"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
Line 5: | Line 5: | ||
use sahana; | use sahana; | ||
select * from gis_wiki; | 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"; | 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";