开发者

Find AM Times and update?

开发者 https://www.devze.com 2023-03-26 10:47 出处:网络
In the mySQL Table, I have a field called CallTime (TIME for开发者_开发技巧mat) How do I find all the AM times and update time to 13:00:00 ?update table set calltime = \'13:00:00\' where calltime <

In the mySQL Table, I have a field called CallTime (TIME for开发者_开发技巧mat)

How do I find all the AM times and update time to 13:00:00 ?


update table set calltime = '13:00:00' where calltime <= '12:00:00'
0

精彩评论

暂无评论...
验证码 换一张
取 消