由于某些原因需要将oracle数据库变成mysql数据库。先用plsqldeveloper将数据库中的表和数据生成出来。
以下几点要注意：
1.mysql里面没有varchar2类型，全部改成varchar。
2.mysql里面没有to_date函数因此需要改为str_to_date。
例如：
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20050923001', 1, 3.5, '3.50', '新*纪文化百货商城', str_to_date('23-09-2005 15:19:24', '%d-%m-%Y %T'), 'admin', 'wgh', '现金');
values ('RT20050923001', 1, 3.5, '3.50', '新*纪文化百货商城', to_date('23-09-2005 15:19:24', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wgh', '现金');3.mysql里面没有number，改为numeric。
------------oracle数据库-----------------------
prompt PL/SQL Developer import file
prompt Created on 2013年3月15日 by Administrator
set feedback off
set define off
prompt Creating TB_GYSINFO...
create table TB_GYSINFO
(
ID VARCHAR2(50) not null,
NAME VARCHAR2(60),
JC VARCHAR2(50),
ADDRESS VARCHAR2(100),
BIANMA VARCHAR2(50),
TEL VARCHAR2(50),
FAX VARCHAR2(50),
LIAN VARCHAR2(50),
LTEL VARCHAR2(50),
YH VARCHAR2(50),
MAIL VARCHAR2(50)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_KHINFO...
create table TB_KHINFO
(
ID VARCHAR2(50) not null,
KHNAME VARCHAR2(50),
JIAN VARCHAR2(50),
ADDRESS VARCHAR2(100),
BIANMA VARCHAR2(50),
TEL VARCHAR2(50),
FAX VARCHAR2(50),
LIAN VARCHAR2(50),
LTEL VARCHAR2(50),
MAIL VARCHAR2(50),
XINHANG VARCHAR2(60),
HAO VARCHAR2(60)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_KUCUN...
create table TB_KUCUN
(
ID VARCHAR2(30) not null,
SPNAME VARCHAR2(50) not null,
JC VARCHAR2(25),
CD VARCHAR2(50),
GG VARCHAR2(50),
BZ VARCHAR2(50),
DW VARCHAR2(10),
DJ NUMBER(19,4),
KCSL INTEGER
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RKTH_DETAIL...
create table TB_RKTH_DETAIL
(
ID INTEGER not null,
RKTHID VARCHAR2(30) not null,
SPID VARCHAR2(50) not null,
DJ NUMBER(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RKTH_MAIN...
create table TB_RKTH_MAIN
(
RKTHID VARCHAR2(30) not null,
PZS FLOAT not null,
JE NUMBER(19,4) not null,
YSJL VARCHAR2(50),
GYSNAME VARCHAR2(100) not null,
RTDATE DATE not null,
CZY VARCHAR2(30) not null,
JSR VARCHAR2(30) not null,
JSFS VARCHAR2(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RUKU_DETAIL...
create table TB_RUKU_DETAIL
(
ID INTEGER not null,
RKID VARCHAR2(30) not null,
SPID VARCHAR2(50) not null,
DJ NUMBER(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RUKU_MAIN...
create table TB_RUKU_MAIN
(
RKID VARCHAR2(30) not null,
PZS INTEGER not null,
JE NUMBER(19,4) not null,
YSJL VARCHAR2(50) not null,
GYSNAME VARCHAR2(100) not null,
RKDATE DATE not null,
CZY VARCHAR2(30) not null,
JSR VARCHAR2(30) not null,
JSFS VARCHAR2(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SELL_DETAIL...
create table TB_SELL_DETAIL
(
ID VARCHAR2(50) not null,
NAME VARCHAR2(60),
JC VARCHAR2(50),
ADDRESS VARCHAR2(100),
BIANMA VARCHAR2(50),
TEL VARCHAR2(50),
FAX VARCHAR2(50),
LIAN VARCHAR2(50),
LTEL VARCHAR2(50),
YH VARCHAR2(50),
MAIL VARCHAR2(50)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SELL_MAIN...
create table TB_SELL_MAIN
(
SELLID VARCHAR2(30) not null,
PZS INTEGER not null,
JE NUMBER(19,4) not null,
YSJL VARCHAR2(50),
KHNAME VARCHAR2(100) not null,
XSDATE DATE not null,
CZY VARCHAR2(30) not null,
JSR VARCHAR2(30) not null,
JSFS VARCHAR2(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SPINFO...
create table TB_SPINFO
(
ID VARCHAR2(50) not null,
SPNAME VARCHAR2(50) not null,
JC VARCHAR2(50),
CD VARCHAR2(60),
DW VARCHAR2(50) not null,
GG VARCHAR2(50) not null,
BZ VARCHAR2(50),
PH VARCHAR2(50),
PZWH VARCHAR2(50),
MEMO VARCHAR2(90),
GYSNAME VARCHAR2(100)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_USERLIST...
create table TB_USERLIST
(
NAME VARCHAR2(50) not null,
USERNAME VARCHAR2(50) not null,
PASS VARCHAR2(50) not null,
QUAN VARCHAR2(2) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_XSTH_DETAIL...
create table TB_XSTH_DETAIL
(
ID INTEGER not null,
XSTHID VARCHAR2(30) not null,
SPID VARCHAR2(50) not null,
DJ NUMBER(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_XSTH_MAIN...
create table TB_XSTH_MAIN
(
XSTHID VARCHAR2(30) not null,
PZS INTEGER not null,
JE NUMBER(19,4) not null,
YSJL VARCHAR2(50),
KHNAME VARCHAR2(100) not null,
THDATE DATE not null,
CZY VARCHAR2(30) not null,
JSR VARCHAR2(30) not null,
JSFS VARCHAR2(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for TB_GYSINFO...
alter table TB_GYSINFO disable all triggers;
prompt Disabling triggers for TB_KHINFO...
alter table TB_KHINFO disable all triggers;
prompt Disabling triggers for TB_KUCUN...
alter table TB_KUCUN disable all triggers;
prompt Disabling triggers for TB_RKTH_DETAIL...
alter table TB_RKTH_DETAIL disable all triggers;
prompt Disabling triggers for TB_RKTH_MAIN...
alter table TB_RKTH_MAIN disable all triggers;
prompt Disabling triggers for TB_RUKU_DETAIL...
alter table TB_RUKU_DETAIL disable all triggers;
prompt Disabling triggers for TB_RUKU_MAIN...
alter table TB_RUKU_MAIN disable all triggers;
prompt Disabling triggers for TB_SELL_DETAIL...
alter table TB_SELL_DETAIL disable all triggers;
prompt Disabling triggers for TB_SELL_MAIN...
alter table TB_SELL_MAIN disable all triggers;
prompt Disabling triggers for TB_SPINFO...
alter table TB_SPINFO disable all triggers;
prompt Disabling triggers for TB_USERLIST...
alter table TB_USERLIST disable all triggers;
prompt Disabling triggers for TB_XSTH_DETAIL...
alter table TB_XSTH_DETAIL disable all triggers;
prompt Disabling triggers for TB_XSTH_MAIN...
alter table TB_XSTH_MAIN disable all triggers;
prompt Deleting TB_XSTH_MAIN...
delete from TB_XSTH_MAIN;
commit;
prompt Deleting TB_XSTH_DETAIL...
delete from TB_XSTH_DETAIL;
commit;
prompt Deleting TB_USERLIST...
delete from TB_USERLIST;
commit;
prompt Deleting TB_SPINFO...
delete from TB_SPINFO;
commit;
prompt Deleting TB_SELL_MAIN...
delete from TB_SELL_MAIN;
commit;
prompt Deleting TB_SELL_DETAIL...
delete from TB_SELL_DETAIL;
commit;
prompt Deleting TB_RUKU_MAIN...
delete from TB_RUKU_MAIN;
commit;
prompt Deleting TB_RUKU_DETAIL...
delete from TB_RUKU_DETAIL;
commit;
prompt Deleting TB_RKTH_MAIN...
delete from TB_RKTH_MAIN;
commit;
prompt Deleting TB_RKTH_DETAIL...
delete from TB_RKTH_DETAIL;
commit;
prompt Deleting TB_KUCUN...
delete from TB_KUCUN;
commit;
prompt Deleting TB_KHINFO...
delete from TB_KHINFO;
commit;
prompt Deleting TB_GYSINFO...
delete from TB_GYSINFO;
commit;
prompt Loading TB_GYSINFO...
prompt Table is empty
prompt Loading TB_KHINFO...
insert into TB_KHINFO (ID, KHNAME, JIAN, ADDRESS, BIANMA, TEL, FAX, LIAN, LTEL, MAIL, XINHANG, HAO)
values ('kh1001', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
insert into TB_KHINFO (ID, KHNAME, JIAN, ADDRESS, BIANMA, TEL, FAX, LIAN, LTEL, MAIL, XINHANG, HAO)
values ('kh1002', 'WB123', 'wb123', '南京山西路', '210009', '123456', '123456', '123456', '123456', 'wb123@', '中国银行', '1234567890');
commit;
prompt 2 records loaded
prompt Loading TB_KUCUN...
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1001', '电吉他', '吉他1', '中*大连', 'FD－3100', '盒', '把', 100, -1000);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1002', '木吉他', '吉他', '中**海', 'HM2100', '盒', '把', 22, 0);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1004', '木吉他', 'mlt', '中*上海', 'HM1000', '盒', '把', 120, 230);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1005', '润*滴眼液', 'RZDYY', '山*正大福*达制药有限公司', '10ml/支', '纸盒', '盒', 10, 19395);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1007', '铅笔', 'QB', '长春', '9*', '沿着', '铅笔厂', 20, 6);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1008', '手工艺品', 'SAYP', '长春市', '1', '5', '长春', 10, 50);
commit;
prompt 6 records loaded
prompt Loading TB_RKTH_DETAIL...
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (1, 'RT20050923001', 'sp1003', 3.5, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (2, 'RT20050926001', 'sp1003', 3.4, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (3, 'RT20051005002', 'sp1003', 3.4, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (4, 'RT20051005002', 'sp1002', 890, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (6, 'RT20071020001', 'sp1005', 431, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (7, 'RT20071020001', 'sp1004', 120, 2);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (8, 'RT20071109001', 'sp1001', 101, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (9, 'RT20071109002', 'sp1005', 40, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (10, 'RT20071206001', 'sp1008', 10, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (11, 'RT20071206002', 'sp1008', 10, 50);
commit;
prompt 10 records loaded
prompt Loading TB_RKTH_MAIN...
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20050923001', 1, 3.5, '3.50', '新*纪文化百货商城', to_date('23-09-2005 15:19:24', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wgh', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20050926001', 1, 34, '0.00', '振撼*琴行', to_date('26-09-2005 14:01:48', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wg', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20051005001', 1, 3.4, '0.00', '振撼*琴行', to_date('05-10-2005 09:09:34', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'hj', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20051005002', 2, 893.4, '0.00', '振撼*琴行', to_date('05-10-2005 13:05:35', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wq', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071020001', 2, 4550, '33333', '振撼*琴行', to_date('20-10-2007 09:10:49', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '33333', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071109001', 1, 101000, '合格', '振撼*琴行', to_date('09-11-2007 14:32:39', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '00', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071109002', 1, 400, '质量有问题', '振撼*琴行', to_date('09-11-2007 15:50:03', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '11', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071206001', 1, 10000, '过期', '吉林省明**业有限公司', to_date('06-12-2007 13:37:51', 'dd-mm-yyyy hh24:mi:ss'), '科技', '55', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071206002', 1, 500, '2', '吉林省明**业有限公司', to_date('06-12-2007 14:39:04', 'dd-mm-yyyy hh24:mi:ss'), '科技', '232', '现金');
commit;
prompt 9 records loaded
prompt Loading TB_RUKU_DETAIL...
prompt Table is empty
prompt Loading TB_RUKU_MAIN...
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016001', 2, 14704, '合格', '振撼*琴行', to_date('16-10-2007 10:32:26', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '某人', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016002', 1, 4000, '合格', '振撼*琴行', to_date('16-10-2007 10:39:28', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '小小', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016003', 2, 9000, '合格', '振撼*琴行', to_date('16-10-2007 10:40:00', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '小小', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016004', 2, 1100, '1111', '振撼*琴行', to_date('16-10-2007 10:42:18', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '1111', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016005', 2, 101100, 'fdsa', '振撼*琴行', to_date('16-10-2007 10:45:14', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', 'fds', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016006', 2, 1577232, 'fdsa', '振撼*琴行', to_date('16-10-2007 10:45:31', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', 'fds', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071020001', 1, 2784, 'fff', '振撼*琴行', to_date('20-10-2007 09:04:36', 'dd-mm-yyyy hh24:mi:ss'), 'mr', 'lzw', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109001', 1, 484, '合格', '新*纪文化百货商城', to_date('09-11-2007 14:27:56', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '玲子', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109002', 1, 100, '合格', '新*纪文化百货商城', to_date('09-11-2007 14:28:24', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '玲子', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109003', 1, 4000, '合格', '振撼*琴行', to_date('09-11-2007 15:49:32', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '小百', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071112001', 1, 10000, '010', '吉林省明**业有限公司', to_date('12-11-2007 10:47:31', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '11', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071206001', 1, 1000, '合格', '吉林省明**业有限公司', to_date('06-12-2007 13:35:56', 'dd-mm-yyyy hh24:mi:ss'), '科技', '一一', '现金');
commit;
prompt 12 records loaded
prompt Loading TB_SELL_DETAIL...
prompt Table is empty
prompt Loading TB_SELL_MAIN...
prompt Table is empty
prompt Loading TB_SPINFO...
prompt Table is empty
prompt Loading TB_USERLIST...
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('111', '1', '1', 'a');
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('管理员', 'admin', '1', 'a');
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('yw', 'yw', '1', 'c');
commit;
prompt 3 records loaded
prompt Loading TB_XSTH_DETAIL...
prompt Table is empty
prompt Loading TB_XSTH_MAIN...
prompt Table is empty
prompt Enabling triggers for TB_GYSINFO...
alter table TB_GYSINFO enable all triggers;
prompt Enabling triggers for TB_KHINFO...
alter table TB_KHINFO enable all triggers;
prompt Enabling triggers for TB_KUCUN...
alter table TB_KUCUN enable all triggers;
prompt Enabling triggers for TB_RKTH_DETAIL...
alter table TB_RKTH_DETAIL enable all triggers;
prompt Enabling triggers for TB_RKTH_MAIN...
alter table TB_RKTH_MAIN enable all triggers;
prompt Enabling triggers for TB_RUKU_DETAIL...
alter table TB_RUKU_DETAIL enable all triggers;
prompt Enabling triggers for TB_RUKU_MAIN...
alter table TB_RUKU_MAIN enable all triggers;
prompt Enabling triggers for TB_SELL_DETAIL...
alter table TB_SELL_DETAIL enable all triggers;
prompt Enabling triggers for TB_SELL_MAIN...
alter table TB_SELL_MAIN enable all triggers;
prompt Enabling triggers for TB_SPINFO...
alter table TB_SPINFO enable all triggers;
prompt Enabling triggers for TB_USERLIST...
alter table TB_USERLIST enable all triggers;
prompt Enabling triggers for TB_XSTH_DETAIL...
alter table TB_XSTH_DETAIL enable all triggers;
prompt Enabling triggers for TB_XSTH_MAIN...
alter table TB_XSTH_MAIN enable all triggers;
set feedback on
set define on
prompt Done.-----------mysql数据库---------------------------
prompt PL/SQL Developer import file
prompt Created on 2013年3月15日 by Administrator
set feedback off
set define off
prompt Creating TB_GYSINFO...
create table TB_GYSINFO
(
ID VARCHAR(50) not null,
NAME VARCHAR(60),
JC VARCHAR(50),
ADDRESS VARCHAR(100),
BIANMA VARCHAR(50),
TEL VARCHAR(50),
FAX VARCHAR(50),
LIAN VARCHAR(50),
LTEL VARCHAR(50),
YH VARCHAR(50),
MAIL VARCHAR(50)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_KHINFO...
create table TB_KHINFO
(
ID VARCHAR(50) not null,
KHNAME VARCHAR(50),
JIAN VARCHAR(50),
ADDRESS VARCHAR(100),
BIANMA VARCHAR(50),
TEL VARCHAR(50),
FAX VARCHAR(50),
LIAN VARCHAR(50),
LTEL VARCHAR(50),
MAIL VARCHAR(50),
XINHANG VARCHAR(60),
HAO VARCHAR(60)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_KUCUN...
create table TB_KUCUN
(
ID VARCHAR(30) not null,
SPNAME VARCHAR(50) not null,
JC VARCHAR(25),
CD VARCHAR(50),
GG VARCHAR(50),
BZ VARCHAR(50),
DW VARCHAR(10),
DJ numeric(19,4),
KCSL integer
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RKTH_DETAIL...
create table TB_RKTH_DETAIL
(
ID INTEGER not null,
RKTHID VARCHAR(30) not null,
SPID VARCHAR(50) not null,
DJ numeric(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RKTH_MAIN...
create table TB_RKTH_MAIN
(
RKTHID VARCHAR(30) not null,
PZS FLOAT not null,
JE numeric(19,4) not null,
YSJL VARCHAR(50),
GYSNAME VARCHAR(100) not null,
RTDATE DATE not null,
CZY VARCHAR(30) not null,
JSR VARCHAR(30) not null,
JSFS VARCHAR(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RUKU_DETAIL...
create table TB_RUKU_DETAIL
(
ID INTEGER not null,
RKID VARCHAR(30) not null,
SPID VARCHAR(50) not null,
DJ numeric(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_RUKU_MAIN...
create table TB_RUKU_MAIN
(
RKID VARCHAR(30) not null,
PZS INTEGER not null,
JE numeric(19,4) not null,
YSJL VARCHAR(50) not null,
GYSNAME VARCHAR(100) not null,
RKDATE DATE not null,
CZY VARCHAR(30) not null,
JSR VARCHAR(30) not null,
JSFS VARCHAR(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SELL_DETAIL...
create table TB_SELL_DETAIL
(
ID VARCHAR(50) not null,
NAME VARCHAR(60),
JC VARCHAR(50),
ADDRESS VARCHAR(100),
BIANMA VARCHAR(50),
TEL VARCHAR(50),
FAX VARCHAR(50),
LIAN VARCHAR(50),
LTEL VARCHAR(50),
YH VARCHAR(50),
MAIL VARCHAR(50)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SELL_MAIN...
create table TB_SELL_MAIN
(
SELLID VARCHAR(30) not null,
PZS INTEGER not null,
JE numeric(19,4) not null,
YSJL VARCHAR(50),
KHNAME VARCHAR(100) not null,
XSDATE DATE not null,
CZY VARCHAR(30) not null,
JSR VARCHAR(30) not null,
JSFS VARCHAR(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_SPINFO...
create table TB_SPINFO
(
ID VARCHAR(50) not null,
SPNAME VARCHAR(50) not null,
JC VARCHAR(50),
CD VARCHAR(60),
DW VARCHAR(50) not null,
GG VARCHAR(50) not null,
BZ VARCHAR(50),
PH VARCHAR(50),
PZWH VARCHAR(50),
MEMO VARCHAR(90),
GYSNAME VARCHAR(100)
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_USERLIST...
create table TB_USERLIST
(
NAME VARCHAR(50) not null,
USERNAME VARCHAR(50) not null,
PASS VARCHAR(50) not null,
QUAN VARCHAR(2) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_XSTH_DETAIL...
create table TB_XSTH_DETAIL
(
ID INTEGER not null,
XSTHID VARCHAR(30) not null,
SPID VARCHAR(50) not null,
DJ numeric(19,4) not null,
SL INTEGER not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating TB_XSTH_MAIN...
create table TB_XSTH_MAIN
(
XSTHID VARCHAR(30) not null,
PZS INTEGER not null,
JE numeric(19,4) not null,
YSJL VARCHAR(50),
KHNAME VARCHAR(100) not null,
THDATE DATE not null,
CZY VARCHAR(30) not null,
JSR VARCHAR(30) not null,
JSFS VARCHAR(10) not null
)
tablespace YWTEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for TB_GYSINFO...
alter table TB_GYSINFO disable all triggers;
prompt Disabling triggers for TB_KHINFO...
alter table TB_KHINFO disable all triggers;
prompt Disabling triggers for TB_KUCUN...
alter table TB_KUCUN disable all triggers;
prompt Disabling triggers for TB_RKTH_DETAIL...
alter table TB_RKTH_DETAIL disable all triggers;
prompt Disabling triggers for TB_RKTH_MAIN...
alter table TB_RKTH_MAIN disable all triggers;
prompt Disabling triggers for TB_RUKU_DETAIL...
alter table TB_RUKU_DETAIL disable all triggers;
prompt Disabling triggers for TB_RUKU_MAIN...
alter table TB_RUKU_MAIN disable all triggers;
prompt Disabling triggers for TB_SELL_DETAIL...
alter table TB_SELL_DETAIL disable all triggers;
prompt Disabling triggers for TB_SELL_MAIN...
alter table TB_SELL_MAIN disable all triggers;
prompt Disabling triggers for TB_SPINFO...
alter table TB_SPINFO disable all triggers;
prompt Disabling triggers for TB_USERLIST...
alter table TB_USERLIST disable all triggers;
prompt Disabling triggers for TB_XSTH_DETAIL...
alter table TB_XSTH_DETAIL disable all triggers;
prompt Disabling triggers for TB_XSTH_MAIN...
alter table TB_XSTH_MAIN disable all triggers;
prompt Deleting TB_XSTH_MAIN...
delete from TB_XSTH_MAIN;
commit;
prompt Deleting TB_XSTH_DETAIL...
delete from TB_XSTH_DETAIL;
commit;
prompt Deleting TB_USERLIST...
delete from TB_USERLIST;
commit;
prompt Deleting TB_SPINFO...
delete from TB_SPINFO;
commit;
prompt Deleting TB_SELL_MAIN...
delete from TB_SELL_MAIN;
commit;
prompt Deleting TB_SELL_DETAIL...
delete from TB_SELL_DETAIL;
commit;
prompt Deleting TB_RUKU_MAIN...
delete from TB_RUKU_MAIN;
commit;
prompt Deleting TB_RUKU_DETAIL...
delete from TB_RUKU_DETAIL;
commit;
prompt Deleting TB_RKTH_MAIN...
delete from TB_RKTH_MAIN;
commit;
prompt Deleting TB_RKTH_DETAIL...
delete from TB_RKTH_DETAIL;
commit;
prompt Deleting TB_KUCUN...
delete from TB_KUCUN;
commit;
prompt Deleting TB_KHINFO...
delete from TB_KHINFO;
commit;
prompt Deleting TB_GYSINFO...
delete from TB_GYSINFO;
commit;
prompt Loading TB_GYSINFO...
prompt Table is empty
prompt Loading TB_KHINFO...
insert into TB_KHINFO (ID, KHNAME, JIAN, ADDRESS, BIANMA, TEL, FAX, LIAN, LTEL, MAIL, XINHANG, HAO)
values ('kh1001', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1');
insert into TB_KHINFO (ID, KHNAME, JIAN, ADDRESS, BIANMA, TEL, FAX, LIAN, LTEL, MAIL, XINHANG, HAO)
values ('kh1002', 'WB123', 'wb123', '南京山西路', '210009', '123456', '123456', '123456', '123456', 'wb123@', '中国银行', '1234567890');
commit;
prompt 2 records loaded
prompt Loading TB_KUCUN...
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1001', '电吉他', '吉他1', '中*大连', 'FD－3100', '盒', '把', 100, -1000);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1002', '木吉他', '吉他', '中**海', 'HM2100', '盒', '把', 22, 0);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1004', '木吉他', 'mlt', '中*上海', 'HM1000', '盒', '把', 120, 230);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1005', '润*滴眼液', 'RZDYY', '山*正大福*达制药有限公司', '10ml/支', '纸盒', '盒', 10, 19395);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1007', '铅笔', 'QB', '长春', '9*', '沿着', '铅笔厂', 20, 6);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1008', '手工艺品', 'SAYP', '长春市', '1', '5', '长春', 10, 50);
commit;
prompt 6 records loaded
prompt Loading TB_RKTH_DETAIL...
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (1, 'RT20050923001', 'sp1003', 3.5, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (2, 'RT20050926001', 'sp1003', 3.4, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (3, 'RT20051005002', 'sp1003', 3.4, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (4, 'RT20051005002', 'sp1002', 890, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (6, 'RT20071020001', 'sp1005', 431, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (7, 'RT20071020001', 'sp1004', 120, 2);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (8, 'RT20071109001', 'sp1001', 101, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (9, 'RT20071109002', 'sp1005', 40, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (10, 'RT20071206001', 'sp1008', 10, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (11, 'RT20071206002', 'sp1008', 10, 50);
commit;
prompt 10 records loaded
prompt Loading TB_RKTH_MAIN...
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1001', '电吉他', '吉他1', '中*大连', 'FD－3100', '盒', '把', 100, -1000);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1002', '木吉他', '吉他', '中**海', 'HM2100', '盒', '把', 22, 0);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1004', '木吉他', 'mlt', '中*上海', 'HM1000', '盒', '把', 120, 230);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1005', '润*滴眼液', 'RZDYY', '山*正大福*达制药有限公司', '10ml/支', '纸盒', '盒', 10, 19395);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1007', '铅笔', 'QB', '长春', '9*', '沿着', '铅笔厂', 20, 6);
insert into TB_KUCUN (ID, SPNAME, JC, CD, GG, BZ, DW, DJ, KCSL)
values ('sp1008', '手工艺品', 'SAYP', '长春市', '1', '5', '长春', 10, 50);
commit;
prompt 6 records loaded
prompt Loading TB_RKTH_DETAIL...
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (1, 'RT20050923001', 'sp1003', 3.5, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (2, 'RT20050926001', 'sp1003', 3.4, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (3, 'RT20051005002', 'sp1003', 3.4, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (4, 'RT20051005002', 'sp1002', 890, 1);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (6, 'RT20071020001', 'sp1005', 431, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (7, 'RT20071020001', 'sp1004', 120, 2);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (8, 'RT20071109001', 'sp1001', 101, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (9, 'RT20071109002', 'sp1005', 40, 10);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (10, 'RT20071206001', 'sp1008', 10, 1000);
insert into TB_RKTH_DETAIL (ID, RKTHID, SPID, DJ, SL)
values (11, 'RT20071206002', 'sp1008', 10, 50);
commit;
prompt 10 records loaded
prompt Loading TB_RKTH_MAIN...
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20050923001', 1, 3.5, '3.50', '新*纪文化百货商城', str_to_date('23-09-2005 15:19:24', '%d-%m-%Y %T'), 'admin', 'wgh', '现金');
values ('RT20050923001', 1, 3.5, '3.50', '新*纪文化百货商城', to_date('23-09-2005 15:19:24', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wgh', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20050926001', 1, 34, '0.00', '振撼*琴行', str_to_date('26-09-2005 14:01:48', '%d-%m-%Y %T'), 'admin', 'wg', '现金');
values ('RT20050926001', 1, 34, '0.00', '振撼*琴行', to_date('26-09-2005 14:01:48', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wg', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20051005001', 1, 3.4, '0.00', '振撼*琴行', str_to_date('05-10-2005 09:09:34', '%d-%m-%Y %T'), 'admin', 'hj', '现金');
values ('RT20051005001', 1, 3.4, '0.00', '振撼*琴行', to_date('05-10-2005 09:09:34', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'hj', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20051005002', 2, 893.4, '0.00', '振撼*琴行', str_to_date('05-10-2005 13:05:35', '%d-%m-%Y %T'), 'admin', 'wq', '现金');
values ('RT20051005002', 2, 893.4, '0.00', '振撼*琴行', to_date('05-10-2005 13:05:35', 'dd-mm-yyyy hh24:mi:ss'), 'admin', 'wq', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071020001', 2, 4550, '33333', '振撼*琴行', str_to_date('20-10-2007 09:10:49', '%d-%m-%Y %T'), 'mr', '33333', '现金');
values ('RT20071020001', 2, 4550, '33333', '振撼*琴行', to_date('20-10-2007 09:10:49', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '33333', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071109001', 1, 101000, '合格', '振撼*琴行', str_to_date('09-11-2007 14:32:39', '%d-%m-%Y %T'), 'mr', '00', '现金');
values ('RT20071109001', 1, 101000, '合格', '振撼*琴行', to_date('09-11-2007 14:32:39', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '00', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071109002', 1, 400, '质量有问题', '振撼*琴行', str_to_date('09-11-2007 15:50:03', '%d-%m-%Y %T'), 'mr', '11', '现金');
values ('RT20071109002', 1, 400, '质量有问题', '振撼*琴行', to_date('09-11-2007 15:50:03', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '11', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071206001', 1, 10000, '过期', '吉林省明**业有限公司', str_to_date('06-12-2007 13:37:51', '%d-%m-%Y %T'), '科技', '55', '现金');
values ('RT20071206001', 1, 10000, '过期', '吉林省明**业有限公司', to_date('06-12-2007 13:37:51', 'dd-mm-yyyy hh24:mi:ss'), '科技', '55', '现金');
insert into TB_RKTH_MAIN (RKTHID, PZS, JE, YSJL, GYSNAME, RTDATE, CZY, JSR, JSFS)
values ('RT20071206002', 1, 500, '2', '吉林省明**业有限公司', str_to_date('06-12-2007 14:39:04', '%d-%m-%Y %T'), '科技', '232', '现金');
values ('RT20071206002', 1, 500, '2', '吉林省明**业有限公司', to_date('06-12-2007 14:39:04', 'dd-mm-yyyy hh24:mi:ss'), '科技', '232', '现金');
commit;
prompt 9 records loaded
prompt Loading TB_RUKU_DETAIL...
prompt Table is empty
prompt Loading TB_RUKU_MAIN...
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016001', 2, 14704, '合格', '振撼*琴行', str_to_date('16-10-2007 10:32:26', '%d-%m-%Y %T'), '测试人员', '某人', '现金');
values ('RK20071016001', 2, 14704, '合格', '振撼*琴行', to_date('16-10-2007 10:32:26', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '某人', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016002', 1, 4000, '合格', '振撼*琴行', str_to_date('16-10-2007 10:39:28', '%d-%m-%Y %T'), '测试人员', '小小', '现金');
values ('RK20071016002', 1, 4000, '合格', '振撼*琴行', to_date('16-10-2007 10:39:28', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '小小', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016003', 2, 9000, '合格', '振撼*琴行', str_to_date('16-10-2007 10:40:00', '%d-%m-%Y %T'), '测试人员', '小小', '现金');
values ('RK20071016003', 2, 9000, '合格', '振撼*琴行', to_date('16-10-2007 10:40:00', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '小小', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016004', 2, 1100, '1111', '振撼*琴行', str_to_date('16-10-2007 10:42:18', '%d-%m-%Y %T'), '测试人员', '1111', '现金');
values ('RK20071016004', 2, 1100, '1111', '振撼*琴行', to_date('16-10-2007 10:42:18', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', '1111', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016005', 2, 101100, 'fdsa', '振撼*琴行', str_to_date('16-10-2007 10:45:14', '%d-%m-%Y %T'), '测试人员', 'fds', '现金');
values ('RK20071016005', 2, 101100, 'fdsa', '振撼*琴行', to_date('16-10-2007 10:45:14', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', 'fds', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071016006', 2, 1577232, 'fdsa', '振撼*琴行', str_to_date('16-10-2007 10:45:31', '%d-%m-%Y %T'), '测试人员', 'fds', '现金');
values ('RK20071016006', 2, 1577232, 'fdsa', '振撼*琴行', to_date('16-10-2007 10:45:31', 'dd-mm-yyyy hh24:mi:ss'), '测试人员', 'fds', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071020001', 1, 2784, 'fff', '振撼*琴行', str_to_date('20-10-2007 09:04:36', '%d-%m-%Y %T'), 'mr', 'lzw', '现金');
values ('RK20071020001', 1, 2784, 'fff', '振撼*琴行', to_date('20-10-2007 09:04:36', 'dd-mm-yyyy hh24:mi:ss'), 'mr', 'lzw', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109001', 1, 484, '合格', '新*纪文化百货商城', str_to_date('09-11-2007 14:27:56', '%d-%m-%Y %T'), 'mr', '玲子', '现金');
values ('RK20071109001', 1, 484, '合格', '新*纪文化百货商城', to_date('09-11-2007 14:27:56', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '玲子', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109002', 1, 100, '合格', '新*纪文化百货商城', str_to_date('09-11-2007 14:28:24', '%d-%m-%Y %T'), 'mr', '玲子', '现金');
values ('RK20071109002', 1, 100, '合格', '新*纪文化百货商城', to_date('09-11-2007 14:28:24', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '玲子', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071109003', 1, 4000, '合格', '振撼*琴行', str_to_date('09-11-2007 15:49:32', '%d-%m-%Y %T'), 'mr', '小百', '现金');
values ('RK20071109003', 1, 4000, '合格', '振撼*琴行', to_date('09-11-2007 15:49:32', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '小百', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071112001', 1, 10000, '010', '吉林省明**业有限公司', str_to_date('12-11-2007 10:47:31', '%d-%m-%Y %T'), 'mr', '11', '现金');
values ('RK20071112001', 1, 10000, '010', '吉林省明**业有限公司', to_date('12-11-2007 10:47:31', 'dd-mm-yyyy hh24:mi:ss'), 'mr', '11', '现金');
insert into TB_RUKU_MAIN (RKID, PZS, JE, YSJL, GYSNAME, RKDATE, CZY, JSR, JSFS)
values ('RK20071206001', 1, 1000, '合格', '吉林省明**业有限公司', str_to_date('06-12-2007 13:35:56', '%d-%m-%Y %T'), '科技', '一一', '现金');
values ('RK20071206001', 1, 1000, '合格', '吉林省明**业有限公司', to_date('06-12-2007 13:35:56', 'dd-mm-yyyy hh24:mi:ss'), '科技', '一一', '现金');
commit;
prompt 12 records loaded
prompt Loading TB_SELL_DETAIL...
prompt Table is empty
prompt Loading TB_SELL_MAIN...
prompt Table is empty
prompt Loading TB_SPINFO...
prompt Table is empty
prompt Loading TB_USERLIST...
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('111', '1', '1', 'a');
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('管理员', 'admin', '1', 'a');
insert into TB_USERLIST (NAME, USERNAME, PASS, QUAN)
values ('yw', 'yw', '1', 'c');
commit;
prompt 3 records loaded
prompt Loading TB_XSTH_DETAIL...
prompt Table is empty
prompt Loading TB_XSTH_MAIN...
prompt Table is empty
prompt Enabling triggers for TB_GYSINFO...
alter table TB_GYSINFO enable all triggers;
prompt Enabling triggers for TB_KHINFO...
alter table TB_KHINFO enable all triggers;
prompt Enabling triggers for TB_KUCUN...
alter table TB_KUCUN enable all triggers;
prompt Enabling triggers for TB_RKTH_DETAIL...
alter table TB_RKTH_DETAIL enable all triggers;
prompt Enabling triggers for TB_RKTH_MAIN...
alter table TB_RKTH_MAIN enable all triggers;
prompt Enabling triggers for TB_RUKU_DETAIL...
alter table TB_RUKU_DETAIL enable all triggers;
prompt Enabling triggers for TB_RUKU_MAIN...
alter table TB_RUKU_MAIN enable all triggers;
prompt Enabling triggers for TB_SELL_DETAIL...
alter table TB_SELL_DETAIL enable all triggers;
prompt Enabling triggers for TB_SELL_MAIN...
alter table TB_SELL_MAIN enable all triggers;
prompt Enabling triggers for TB_SPINFO...
alter table TB_SPINFO enable all triggers;
prompt Enabling triggers for TB_USERLIST...
alter table TB_USERLIST enable all triggers;
prompt Enabling triggers for TB_XSTH_DETAIL...
alter table TB_XSTH_DETAIL enable all triggers;
prompt Enabling triggers for TB_XSTH_MAIN...
alter table TB_XSTH_MAIN enable all triggers;
set feedback on
set define on
prompt Done.
--------------------------------------------------
http://www.docin.com/p-258809939.html
http://java-cn.iteye.com/blog/1504563
mysql中实现日期格式化的方法为date_to_str('日期字符串','日期格式'),而且mysql中的日期格式的写法和oracle也不同。
mysql中用法为：str_to_date('2012-05-01 23:59:59','%Y-%m-%d %T')
%Y：代表4位的年份
%y：代表2为的年份
%m：代表月, 格式为(01……12)
%c：代表月, 格式为(1……12)
%d：代表月份中的天数,格式为(00……31)
%e：代表月份中的天数, 格式为(0……31)
%H：代表小时,格式为(00……23)
%k：代表 小时,格式为(0……23)
%h： 代表小时,格式为(01……12)
%I： 代表小时,格式为(01……12)
%l ：代表小时,格式为(1……12)
%i： 代表分钟, 格式为(00……59) %r：代表 时间,格式为12 小时(hh:mm:ss [AP]M)
%T：代表 时间,格式为24 小时(hh:mm:ss) %S：代表 秒,格式为(00……59)
%s：代表 秒,格式为(00……59)
http:///techdoc/database/2009/06/06/1116903.shtml
1.导出整个数据库
mysqldump -u 用户名 -p 数据库名 > 导出的文件名
mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.导出一个表
mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名
mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.导出一个数据库结构
mysqldump -u wcnc -p -d --add-drop-table smgp_apps_wcnc >d:\wcnc_db.sql
-d 没有数据 --add-drop-table 在每个create语句之前增加一个drop table
4.导入数据库
常用source 命令
进入mysql数据库控制台，
如mysql -u root -p
mysql>use 数据库
然后使用source命令，后面参数为脚本文件(如这里用到的.sql)
mysql>source d:\wcnc_db.sql本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
