INSERT INTO recommend ( SELECT ut.userid,it.itemid, NOW() FROM user_tag ut,item_tag it WHERE EXISTS ( SELECT it.tagid FROM item_tag it WHERE it.tagid IN (SELECT ut.tagid FROM user_tag ut) ) )
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....