| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 1084 人关注过本帖
标题:联系各位老师
只看楼主 加入收藏
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
等 级:贵宾
威 望:41
帖 子:766
专家分:2517
注 册: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
快速回复:联系各位老师
数据加载中...
 
   



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

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