SQL语句,求高手解决

显示全部楼层 · 2008-11-19 16:19:50

select * from jet_number..jet_group where 1=1
from后面jet_number..jet_group什么意思，有这种用法么？
还有这个
insert into jet_number..jet_export_temp(temp_id,usernumber)

千问 · 2008-11-19 16:19:50

jet_number..jet_group jet_number是DATABASE的名称。jet_group是jet_number的数据库的名称select * from jet_number..jet_group where 1=1 的确有这种用法。insert into jet_number..jet_export_temp(temp_id,usernumber)少了values的内容。insert into jet_number..jet_export_temp(temp_id,usernumber) values(1,2)...

千问 · 2008-11-19 16:19:50

楼上的解答对了一半insert into jet_number..jet_export_temp(temp_id,usernumber)这个语句是因为表中2个列都允许为空...

千问 · 2008-11-19 16:19:50

jet_number..jet_group jet_number是加的名称。 jet_group是jet_number的数据库的表名..两点是因为省略了所有者.相当于更新当前DB之外的DB...