To set all Boys have an id starting from 10001 onwards and all Girls from 20001 in already existing IDs, use the following query. SET @i = 10000 ; UPDATE users SET uID = (@i := @i + 1) where gender =' b ' ORDER BY regDate ; The italic items can be changed as applicable If the uID already exists in this range, then first add a large value like 100000 to all the IDs so that duplicacy error does not appear.
This article will help you migrate your Whatsapp BUSINESS chat data (alongwith Media) from iPhone to Android for Free. Step 1 - Move data from Whatsapp business to Whatsapp Time required: 5 Mins Install whatsapp on your iPhone. Proceed using the same number as that of Whatsapp business in that iPhone. The system will give a warning that business settings will be lost. Here you need to agree to losing your catalogues and auto replies. You can add them back later manually when the migration to android is completed. Once the process is completed, check the data in Whatsapp and Uninstall (Remove) Whatsapp Business App from your iPhone and proceed to step 2. Step 2 - Migrate data from iPhone to Android Time required: 1-2 Hours (Depends on data size.) Take a backup of Whatsapp by going to Settings > Chat > Chat Backup. This is to ensure that all data is safe and you have a recovery option in case anything goes wrong. Install Whatsapp in the Android phone. Proceed with the same number u...