联系各位老师
各位老师好!我用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