Skip to main content

Posts

Showing posts with the label SQL DATABASE

Top Tips to Make Money with Google AdSense

Merge two whatsapp database into one.

Many people want their whatsapp message history(backup’s from different devices ) to be in the same device that they are using. Specially me , I don’t want to lose any of my messages. So hears for those peoples. I will be as clear as possible, you can ask any query if you cant understand, There you go. 1). Open the old database file in SQLite Database Browser (  http://sqlitebrowser.sourceforge.net/  ). Open the table messages in Browse Data. Press the Button ” > ” as often as necessary to get to the last page. Scroll down to the last message. Now write down the number (_id) of that last message, e.g. 65422 2). Now open the new database file in SQLite Database Browser. Open the table messages in Browse Data. Click on the first entry (which has most fields with value “-1”). Click on Delete Record. Have a look at the now first entry and write down the number (_id) of that first message, e.g. 12 Now Click on Execute SQL and execute the following SQL statement: UPDATE messages se