Scribd
Upload
4 views2 pages

User Session Name Updates SQL

The document contains a series of SQL update statements that modify the 'session_name' field for various users based on their 'class_name', 'section', and 'school_orgid'. Each update targets specific combinations of these fields to assign new session names ranging from '643' to '718'. All updates are directed towards users within the same school organization identified by 'school_orgid' = '21838'.

Uploaded by

vamshi kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views2 pages

User Session Name Updates SQL

The document contains a series of SQL update statements that modify the 'session_name' field for various users based on their 'class_name', 'section', and 'school_orgid'. Each update targets specific combinations of these fields to assign new session names ranging from '643' to '718'. All updates are directed towards users within the same school organization identified by 'school_orgid' = '21838'.

Uploaded by

vamshi kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

UPDATE users

SET session_name = '643'


WHERE class_name = '2029'
AND section = '2819'
AND school_orgid = '21838';

UPDATE users
SET session_name = '643'
WHERE class_name = '2029'
AND section = '2820'
AND school_orgid = '21838';

UPDATE users
SET session_name = '715'
WHERE class_name = '2027'
AND section = '2814'
AND school_orgid = '21838';

UPDATE users
SET session_name = '715'
WHERE class_name = '2028'
AND section = '2815'
AND school_orgid = '21838';

UPDATE users
SET session_name = '715'
WHERE class_name = '2028'
AND section = '2816'
AND school_orgid = '21838';

UPDATE users
SET session_name = '715'
WHERE class_name = '2029'
AND section = '2818'
AND school_orgid = '21838';

UPDATE users
SET session_name = '716'
WHERE class_name = '2032'
AND section = '2822'
AND school_orgid = '21838';

UPDATE users
SET session_name = '716'
WHERE class_name = '2032'
AND section = '2823'
AND school_orgid = '21838';

UPDATE users
SET session_name = '716'
WHERE class_name = '2033'
AND section = '2825'
AND school_orgid = '21838';

UPDATE users
SET session_name = '717'
WHERE class_name = '2033'
AND section = '2824'
AND school_orgid = '21838';
UPDATE users
SET session_name = '717'
WHERE class_name = '2034'
AND section = '2826'
AND school_orgid = '21838';

UPDATE users
SET session_name = '717'
WHERE class_name = '2035'
AND section = '2828'
AND school_orgid = '21838';

UPDATE users
SET session_name = '717'
WHERE class_name = '2039'
AND section = '2832'
AND school_orgid = '21838';

UPDATE users
SET session_name = '718'
WHERE class_name = '2035'
AND section = '2827'
AND school_orgid = '21838';

UPDATE users
SET session_name = '718'
WHERE class_name = '2036'
AND section = '2829'
AND school_orgid = '21838';

UPDATE users
SET session_name = '718'
WHERE class_name = '2037'
AND section = '2830'
AND school_orgid = '21838';

UPDATE users
SET session_name = '718'
WHERE class_name = '2038'
AND section = '2831'
AND school_orgid = '21838';

You might also like