Create hundreds of WordPress Users using SQL query manually

="INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) VALUES ("&A4&", '"&B4&"', MD5('"&E4&"'), '"&LOWER(B4)&"', '"&LOWER(B4)&"@gmail.com', '', '2021-01-018 11:33:20', '1609932803:$P$B7LBiFY6NR6NrXFrSCrO7/54DqNi8B/', 0, '"&C4&"');"
 
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'nickname', '"&B4&"');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'first_name', '"&C4&"');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'last_name', '');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'description', '');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'rich_editing', 'true');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'syntax_highlighting', 'true');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'comment_shortcuts', 'false');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'admin_color', 'fresh');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'use_ssl', '0');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'show_admin_bar_front', 'true');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'locale', '');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_capabilities', 'a:1:{s:10:\""subscriber\"";b:1;}');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_user_level', '0');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_multiple_roles', 'a:2:{i:0;s:23:\""um_erlms-entry-operator\"";i:1;s:14:\""um_data-viewer\"";}');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_user_profile_url_slug_user_login', '"&B4&"');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'account_status', 'approved');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'sw_pwd', '"&E4&"');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'dismissed_wp_pointers', 'wp496_privacy');"
 ="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'synced_gravatar_hashed_id', '354fbe8cea21bca9871847af17cb1970');"

="INSERT INTO t_site_user_map (UserId, InstanceId, IsActive) VALUES('"&A4&"', 1580086744006, 1);"

mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_users.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_usermeta.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_t_site_user_map.sql

mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_users.sql mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_usermeta.sql
 mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_t_site_user_map.sql