Some sql gueries for memory

sql_query_levelchinese.txt

1. ********* step 1

CREATE TABLE `levelchinese`.`temp_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=24644 DEFAULT CHARSET=utf8mb4;


2. ********* step 2 write in new table dates from wp_usermeta

insert into levelchinese.temp_usermeta (user_id, meta_key, meta_value)
select user_id, meta_key, meta_value
from levelchinese.wp_usermeta
where wp_usermeta.user_id in (SELECT ID FROM levelchinese.wp_users where ID != 1)
and (wp_usermeta.meta_key = 'wp_capabilities' or wp_usermeta.meta_key = 'wp_user_level');


3. ************ step 3 change keys

update levelchinese.temp_usermeta set meta_key = replace(meta_key, 'wp_capabilities', 'wpcn_capabilities') where meta_key = 'wp_capabilities';
update levelchinese.temp_usermeta set meta_key = replace(meta_key, 'wp_user_level', 'wpcn_user_level') where meta_key = 'wp_user_level';

4. ************ step 4 write values from temporary tables in wp_usermeta

insert into levelchinese.wp_usermeta (user_id, meta_key, meta_value)
select user_id, meta_key, meta_value
from levelchinese.temp_usermeta;

5. ************ step 5

DROP TABLE levelchinese.temp_usermeta;


    *********** temp
insert into levelchinese.temp_usermeta (user_id, meta_key, meta_value)
select user_id, meta_key, meta_value
from levelchinese.wp_usermeta
where wp_usermeta.user_id = 1356 /*in (select id FROM levelchinese.wp_users)*/
and wp_usermeta.meta_key = 'wp_capabilities';

insert into levelchinese.temp_usermeta (user_id, meta_key, meta_value)
select user_id, meta_key, meta_value
from levelchinese.wp_usermeta
where wp_usermeta.user_id = 1356 /*in (select id FROM levelchinese.wp_users)*/
and wp_usermeta.meta_key = 'wp_user_level';

SELECT * FROM levelchinese.wp_usermeta
where meta_key like 'wpcn_%';

SELECT ID FROM levelchinese.wp_users
where ID != 1;

    ************ temp