Sql
From Chaehyun
(Difference between revisions)
Xlos (Talk | contribs)
(Created page with "= sql = * INSERT IGNORE INTO user_log (user_id, item_id, date_created, tag) SELECT a.id, b.code, b.date, 'like' FROM user_id a, review b WHERE a.author=b.author AND b.point >= 7;")
Newer edit →
(Created page with "= sql = * INSERT IGNORE INTO user_log (user_id, item_id, date_created, tag) SELECT a.id, b.code, b.date, 'like' FROM user_id a, review b WHERE a.author=b.author AND b.point >= 7;")
Newer edit →
Revision as of 03:38, 18 October 2012
sql
- INSERT IGNORE INTO user_log (user_id, item_id, date_created, tag) SELECT a.id, b.code, b.date, 'like' FROM user_id a, review b WHERE a.author=b.author AND b.point >= 7;