创建视图错误
delimiter//
CREATE adurl_view_2006new AS
select a.*
from AdPlan_Today a,AdPlan b
where a.AdPlanID=b.AdPlanID
and b.TotalNum > b.HaveShowTimes*a.Modify;//You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'adurl_view_2006new AS
select a.*
from AdPlan_Today a,AdPlan b
where a.AdPlanID=' at line 1如何解决
delimiter//
CREATE adurl_view_2006new AS
select a.*
from AdPlan_Today a,AdPlan b
where a.AdPlanID=b.AdPlanID
and b.TotalNum > b.HaveShowTimes*a.Modify;//You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'adurl_view_2006new AS
select a.*
from AdPlan_Today a,AdPlan b
where a.AdPlanID=' at line 1如何解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货