oracle转换为mysql_oracle转换为mysql

怎么把CREATETABLEjphoto_picvisit(i_idNUMBER(10)NOTNULL,vc_memberidVARCHAR2(255),i_picidNUMBER(10),vc_visittimeCHAR(20)DEFAULT'0000-00-0000:00:00'NOTNULL,PRIMARYKEY(i_id))...

怎么把

CREATE TABLE jphoto_picvisit

(

i_id NUMBER(10) NOT NULL,

vc_memberid VARCHAR2(255),

i_picid NUMBER(10),

vc_visittime CHAR(20) DEFAULT '0000-00-00 00:00:00' NOT NULL,

PRIMARY KEY (i_id)

);

alter table JPHOTO_PHOTODOWN modify VC_AUTHORID null;

alter table JPHOTO_PHOTODOWN modify VC_MEMBERID null;

alter table JPHOTO_PHOTODOWN modify VC_FIELD2 CHAR(10);

alter table JPHOTO_PHOTOINFO modify VC_UPLOADERID CHAR(60);

alter table JPHOTO_INFO add I_TYPE VARCHAR2(5);

delete from jphoto_logconfig where vc_state='导出' and vc_modulename ='图片维护';

INSERT INTO jphoto_logconfig(vc_module,vc_modulename,vc_state,i_type,i_start,i_modalorderid,i_orderid) VALUES('p_2_2','图片维护','上传图片',0,0,21,142);

insert into JPHOTO_LOGCONFIG (VC_MODULE, VC_MODULENAME, VC_STATE, I_TYPE, I_START, I_ORDERID, I_MODALORDERID) values ('p_2_2', '图片维护', '取消推荐', 0, 1, 143, 21);

insert into JPHOTO_LOGCONFIG (VC_MODULE, VC_MODULENAME, VC_STATE, I_TYPE, I_START, I_ORDERID, I_MODALORDERID) values ('p_1_2', '信息维护', '取消推荐', 0, 1, 144, 19);

alter table merp_pub_roledetail add i_orderid number(10);

alter table JPHOTO_COMMENT modify VC_CONTENT VARCHAR2(1000);

insert into JPHOTO_LOGCONFIG (VC_MODULE, VC_MODULENAME, VC_STATE, I_TYPE, I_START, I_ORDERID, I_MODALORDERID)values ('p_4_1', '待审核信息', '取消推荐', 0, 1, 145, 14);

insert into JPHOTO_LOGCONFIG (VC_MODULE, VC_MODULENAME, VC_STATE, I_TYPE, I_START, I_ORDERID, I_MODALORDERID)values ('p_4_2', '待审核图片', '取消推荐', 0, 1, 146, 15);

update jphoto_unitstyle set vc_name='标题控制字数' where vc_name='标题控制字数并含"更多"'

转换为mysql语句啊

展开