It is best practice in all cases to ensure to you make a backup of your database. Even with SELECT and DELETE, you may unknowingly make a typing mistake. Anytime you start messing around with the database directly, ensure you first make a backup, so that you can easily restore the database in case you mess up something unintentionally.
Another trick is to use a "SELECT INTO " statement, to put all of the data you are about to delete into a separate table, and then perform the delete operation. This way, it is relatively easy to see what you have deleted and restore it once again, without reverting to a complete backup restore. Regards, Jason 2011/9/12 Muhire Andrew <muhireand...@yahoo.com> > Thank you all, > Great Knut its rilly good to select first and then delete because it can > cause problems in case i delete the needed data. > > > > > ------------------------------ > > > *Muhire Andrew > * > *HMIS/Ministry of Health* > *andrew.muh...@moh.gov.rw* > *God is my provider.* > > > ------------------------------ > *From:* Knut Staring <knu...@gmail.com> > *To:* Lars Helge Øverland <larshe...@gmail.com> > *Cc:* Muhire Andrew <muhireand...@yahoo.com>; > dhis2-users@lists.launchpad.net; dhis2-d...@lists.launchpad.net > *Sent:* Monday, September 12, 2011 3:56 PM > *Subject:* Re: [Dhis2-devs] Dear Dhis2 users how can i delete? > > As a rule of thumb, it is usually wise to do a SELECT before a DELETE, so > that you are 100% sure you are not deleting data you really need. > > In this case: > > select * from datavalue_audit where dataelementid=<id>; > select * from datavalue where dataelementid=<id>; > > Knut > > 2011/9/12 Lars Helge Øverland <larshe...@gmail.com> > > Hi Andrew, > > you need to remove the data with SQL in the database. Run: > > delete from datavalue_audit where dataelementid=<id>; > delete from datavalue where dataelementid=<id>; > > and replace <id> with the dataelementid of the one you want to remove. > > You can then go ahead and delete the data element in the user interface. > > > > Lars > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > -- > Knut Staring > Informatics, U. of Oslo > http://hisp.uio.no > +4791880522 > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
