请问：如何把数据库表中的数据保存为一个sql文件？

am2000 2001-07-18 11:44:34

...全文

281 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

hansonman 2001-07-18

打赏
举报

上面三层说的是pb6.5

guest007 2001-07-18

打赏
举报

看错题目了，呵呵
同意楼上

guest007 2001-07-18

打赏
举报

在7.0下
右键此表，export syntax,就OK了

pbdesigner 2001-07-18

打赏
举报

PB7:在该表上弹右键，edit data,菜单row\save row as(选sql文件类型）

hansonman 2001-07-18

打赏
举报

design--->start log
object--->export systex to log (可加很多表)
design--> save log as (保存为sql 文件)

wangsw 2001-07-18

打赏
举报

用得着那么折腾吗？

dian 2001-07-18

打赏
举报

你要这个干嘛，如果是为了以后导入，当心执行不完就死掉，当数据过多、文本过长时会无法执行完毕（好象是SQLSERVER）

am2000 2001-07-18

打赏
举报

另外，我在用powerdesigner生成测试数据的时候，生成的脚本数据为乱码：请大虾指点一二：

insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('Z
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('Y
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('D蒒
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('S?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('S
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('XD
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('14??
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('?
insert into YS_SHDWXX (SHDWID, SHDWMC, LXR, LXDH, YZBM, DZYJ, CZID) values ('
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' ', 'BC65?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 0', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 1', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 2', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 3', '錜K?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 4', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 5', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 6', 'G?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 7', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 8', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' 9', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' A', '叚
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' B', 'N?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' C', '?
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' D', '8慪
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' E', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' F', '
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' G', '诱燉
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' H', 'M
insert into YS_FY (FYID, FYMC, FYLBID, JCBZ, BZ) values (' I', '0

am2000 2001-07-18