Shulou(Shulou.com)06/01 Report--

ORDER BY and LIMIT are not supported when updating multiple tables.

Mysql > update Subscribers2 sdirection tmpstores Subscribers01 t set s.date='2015-01-01'

-> s.LastAccessTimeStamp=unix_timestamp (date '2015-01-01')

-> where s.MSISDN=t.MSISDN and t.id between 1 and 5000 limit 2000

ERROR 1221 (HY000): Incorrect usage of UPDATE and LIMIT

Mysql > update Subscribers2 sdirection tmpstores Subscribers01 t set s.date='2015-01-01'

-> s.LastAccessTimeStamp=unix_timestamp (date '2015-01-01')

-> where s.MSISDN=t.MSISDN and t.id between 1 and 5000 order by s.date

ERROR 1221 (HY000): Incorrect usage of UPDATE and ORDER BY

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.