MYSQL 批量更新

By kcersing , 17 一月, 2018

批量更新

UPDATE <表> SET <字段>=REPLACE(<字段>,'132132','132')

查询

SELECT

sum(user_money)

FROM

   $table

WHERE

   (

       $table .change_time BETWEEN UNIX_TIMESTAMP('2017-8-8 0:0:00')

       AND UNIX_TIMESTAMP('2017-8-9 0:0:00')

   )

AND id=XXX

标签