第一条:SELECT COUNT(*) FROM resource c WHERE CHAR_LENGTH(c.title) = CHAR_LENGTH(CAST(c.title AS UNSIGNED INTEGER));
第二条:SELECT COUNT(*) FROM resource c ,program_video_picture pvp WHERE pvp.resourceid = c.id; 现在就是要把这两条查询语句查询到的结果加起来,求大神解答!!!
第二条:SELECT COUNT(*) FROM resource c ,program_video_picture pvp WHERE pvp.resourceid = c.id; 现在就是要把这两条查询语句查询到的结果加起来,求大神解答!!!
Union All
SELECT COUNT(*) FROM resource c ,program_video_picture pvp WHERE pvp.resourceid = c.id
(
SELECT COUNT(*) as cFROM resource c WHERE CHAR_LENGTH(c.title) = CHAR_LENGTH(CAST(c.title AS UNSIGNED INTEGER))
union all
SELECT COUNT(*) FROM resource c ,program_video_picture pvp WHERE pvp.resourceid = c.id
) t