如何更改时间? [英] How to change curtime?

问题描述

如何在MySQL中更改curtime值，我运行查询SELECT CURTIME()，结果为18:49:12.

How to change curtime value in MySQL, I run query SELECT CURTIME() and the result is 18:49:12.

我想将值更改为17:49:12

如果有人知道这样做的好方法，我将非常感谢您的帮助.

If anyone knows a good way to do this I'd very much appreciate your help.

推荐答案

您可以手动设置time-zone，如下所示:

You could be set the time-zone manually, like so:

SET GLOBAL time_zone = '-1:00';

或设置为您的系统时间:

or to set to your system time:

SET GLOBAL time_zone = SYSTEM;

有关详细信息，请参见文档

See the documentation for more information.

这篇关于如何更改时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！