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

am2000 2001-07-18 11:44:34
...全文
168 点赞 收藏 10
写回复
10 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
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
to pbdesigner(MIS/ERP开发):这样每次只能保存一个表啊 
回复
am2000 2001-07-18
to hansonman(何百万):里面的数据没有吧
回复
相关推荐
发帖
数据库相关
创建于2007-09-28

734

社区成员

PowerBuilder 数据库相关
申请成为版主
帖子事件
创建了帖子
2001-07-18 11:44
社区公告
暂无公告