//steps to access ransim Database

docker exec -ti ran-mariadb bash
root@mariadb:/# mysql -uroot 
use ransim_db;

//renaming as per the container name used in honeycomb setup
update gnbdufunction set gnbduname='110' where gnbduid=110;update gnbdufunction set gnbduname='220' where gnbduid=220;update gnbdufunction set gnbduname='330' where gnbduid=330;update gnbdufunction set gnbduname='440' where gnbduid=440;update gnbdufunction set gnbduname='550' where gnbduid=550;update gnbdufunction set gnbduname='660' where gnbduid=660;select * from gnbdufunction;

//view plmninfo data
select * from plmninfo;

//delete plmninfo data
delete from plmninfo;INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15289,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15290,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15296,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15687,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15689,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15155,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15174,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15175,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15176,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15825,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15425,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15426,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15826,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,14000,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,13999,11,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,10896,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,11561,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,11562,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,11568,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,11569,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,10897,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,13905,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,13910,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,14655,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,14656,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,14427,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15360,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15361,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15548,22,3,5,3000,'2020-11-20 07:56:49');INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15549,22,3,5,3000,'2020-11-20 07:56:49');select * from plmninfo;