Skip to main content

MySQL -Setting up ID in incrementing values

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.


Comments

Post a Comment

Your comment will be published after approval by the admin.

Popular posts from this blog

Whatsapp Business Migration from iPhone to Android for Free

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...
Post a Comment
Read more

Checker System Integrated

 Now checker should check and Lock each Markslip. The entry cannot be edited further by the subject teacher once it has been locked. Alongwith this, we have added the concept of QuickNotes - A means of communication within Portal which can be used for reporting error by the checker to the Subject Teacher. The communication system will be expanded in future.
1 comment
Read more

KVMIS Upcoming Features

The following features are in the master plan and will be be integrated in the MIS Portal sooner or later. If you have any suggestion, we request you to kindly share the same in comments below so that we can include them in the planner. Legends: Pending | Under Development | Completed | Dropped Employee Level Prompt to enter/update mobile number, email and date of birth  Verification of Enrollment data every month by class teacher  Marking of Absentees on daily basis and SMS to parents of absentees Facility to enter date of admission of students KV Level Employee's Initial password display after adding employee. [221028] Verification of Enrollment data every month SMS to Principal with list of absentees in X and XII Regional Level Facility to view performance of each individual teacher using a Drill Down method. Various types of result summarries for Classes X and XII Student / Parent Level Facility to view daily attendance  Global features that affect all or multiple t...
Post a Comment
Read more

Support for 6 Digit roll Nos. Integrated

 The system has been updated to support 6 Digit Roll Nos.
Post a Comment
Read more

Improvements & Fixes - Oct 2022

 The following improvements & fixes have been done in Oct 2022 Oct 01 Long alternate mobile number was blocking the student edit. Restriction imposed to allow 10 digit mobile and alternate mobile The StepIN was not working after updating the Employee Code. Allowed Length of City Name for KV increased from 15 to 25 characters Enrollment Report (Format-2) was including inactive students too. The issue has been fixed. Oct 02 Oral removed from Classes VI-VIII and weightage adjusted accordingly. No action required from KVs as output will be modfied automatically. Oct 04 Error in viewing Entry status of Monthly Test by School has been fixed. Reports of Monthly Test of Class XII have been integrated. Total and Percentage added in Month Wise Monthly Test Report at School Level Commerce added as a subject for creating staff. Commerce will not be found as a subject in classes XI & XII. Rather, Accountancy and Business Statistics will be the subjects and will be taken by the PGT Comme...
Post a Comment
Read more

Broadsheet Integrated

 
Post a Comment
Read more