docker run --name oracle  -p 9090:8080 -p 1521:1521 sath89/oracle-xe-11g
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=wordpress --restart=always -d mysql:5.7;

docker exec -it oracle bash
sqlplus sys/oracle@127.0.0.1:1521/xe as sysdba
sqlplus system/oracle@//localhost:1521/xe

cat /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora|grep SERVICE_NAME


sqlplus sys/oracle@xe as sysdba

create tablespace myts  datafile  '/u01/app/oracle/oradata/XE/myts.dbf'  size 100M autoextend on next 5M maxsize 400M;
create user scott identified by tiger;
grant connect, resource to scott;
alter user scott default tablespace myts;

alter user scott identified by your-passwd;


create user ESSMWEB identified by oracle;
grant connect, resource to ESSMWEB;
alter user ESSMWEB default tablespace myts;
alter user ESSMWEB identified by oracle;

create table import_result2 as select k.USERID,k.AGENTID,k.USERNAME,k.SUPAGENT,k.CHARGE,k.POINT,b.BALANCE,a.mobile,a.username realname from import_auth_keep k join import_auth_blance b on k.USERID=b.USERID join import_user_auth a on k.USERID=a.id;


update clhimport_result r,user u set u.agentid = r.AGENTID,u.nickname=r.`USERNAME`,u.supagent = r.SUPAGENT,u.charge = r.CHARGE,u.point = r.POINT,u.account = r.`BALANCE`,u.mobile = r.`PHONE`,u.username = r.`REALNAME` where u.id=r.USERID


select id,agentid,nickname,supagent,charge,point,account,mobile,username from user;