Navigation
Home
Projects
Patents
Publications
Changes
Search
SEARCH
TOOLBOX
LANGUAGES
Sql
Sql
From Chaehyun
Revision as of 03:40, 18 October 2012 by
Xlos
(
Talk
|
contribs
)
(
diff
)
← Older revision
|
Latest revision
(
diff
) |
Newer revision →
(
diff
)
Jump to:
navigation
,
search
join
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;