DROP TEMPORARY TABLE IF EXISTS userlist;
CREATE TEMPORARY TABLE userlist(UserID int not null default 0);
insert into userlist(UserID) values(166);
-- 关联查询,如果users中有166返回1
select count(ul.UserID) from userlist as ul inner join users as u on u.UserID=ul.UserID limit 1;
DROP TEMPORARY TABLE IF EXISTS userlist;
------这内容8个c币?