标题:联系各位老师
只看楼主
yd1954
Rank: 2
来 自:辽宁沈阳
等 级:论坛游民
帖 子:143
专家分:21
注 册:2016-7-1
结帖率:100%
已结贴  问题点数:20 回复次数:2 
联系各位老师
各位老师好!
我用sql语句查询后,用  into table 表2  建立了一个新表,数据更新后,再运行这个语句,提示错误:表2在数据库已经存在,或者不能创建表2.
怎么解决?
语句如下

CLOSE DATABASES
SET TALK OFF
SET SAFETY OFF

USE 表1
SELECT h1,h2,h3,z59,z60,z61,z62,z63,z64;
 from 表1 WHERE z59#95 and z59#69 AND z59#114 AND z59#50 AND z59#93 AND z59#71 AND z59#88 AND z59#71 AND z59#88 AND z59#76 AND z59#82;
 AND z60#95 AND z60#69 AND z60#114 AND z60#50 AND z60#93 AND z60#71 AND z60#88 AND z60#71 AND z60#88 AND z60#76 AND z60#82;
 AND z61#95 AND z61#69 AND z61#114 AND z61#50 AND z61#93 AND z61#71 AND z61#88 AND z61#71 AND z61#88 AND z61#76 AND z61#82;  
AND z62#95 AND z62#69 AND z62#114 AND z62#50 AND z62#93 AND z62#71 AND z62#88 AND z62#71 AND z62#88 AND z62#76 AND z62#82;
AND z63#95 AND z63#69 AND z63#114 AND z63#50 AND z63#93 AND z63#71 AND z63#88 AND z63#71 AND z63#88 AND z63#76 AND z63#82;
AND z64#95 AND z64#69 AND z64#114 AND z64#50 AND z64#93 AND z64#71 AND z64#88 AND z64#71 AND z64#88 AND z64#76 AND z64#82 ;
into TABLE 表2
搜索更多相关主题的帖子: and 语句 SET 老师 联系 
2020-03-20 09:15
xuminxz
Rank: 11Rank: 11Rank: 11Rank: 11
等 级:贵宾
威 望:40
帖 子:749
专家分:2475
注 册:2011-5-8
得分:10 
数据库中的表必须先删除(可以用DROP TABLE 命令)

dBase有人接盘了。
2020-03-20 16:00
瓜瓜1990
Rank: 7Rank: 7Rank: 7
等 级:贵宾
威 望:18
帖 子:125
专家分:699
注 册:2020-2-25
得分:10 
改下表名,和数据库里的表重名了

piu~piu~
2020-03-20 19:14



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-500451-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.011710 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved