blocks|key|3028536|text|首先，您还不需要更改任何内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028537|3028538|这些非标准行为仍然是时间戳的缺省行为，但从MySQL+5.6.6开始，这些非标准行为将被弃用，并且在启动时会出现此警告|blockquote|3028539|3028540|3028541|现在，如果你想移动到new+behaviors，你必须在你的my.cnf中的mysqld部分添加这一行。|offset|length|style|CODE|3028542|explicit_defaults_for_timestamp+=+1|code-block|syntax|javascript|3028543|my.cnf+(或其他配置文件)的位置因系统而异。如果找不到，请参考https://dev.mysql.com/doc/refman/5.7/en/option-files.html|3028544|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp|1|https://dev.mysql.com/doc/refman/5.7/en/option-files.html^0|0|0|0|0|0|U|6|A|D|0|0|0|Y|1L|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|19|8|@$J|1A|K|1B|L|M]]|9|@$J|1C|K|1D|1|1E]]|A|$]]|$1|N|3|O|5|P|7|1F|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|1G|8|@]|9|@$J|1H|K|1I|1|1J]]|A|$]]|$1|U|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|X|Y|Z|A|$10|13]]]]

First you don't need to change anything yet.

<blockquote>
 Those nonstandard behaviors remain the default for TIMESTAMP but as of
 MySQL 5.6.6 are deprecated and this warning appears at startup
</blockquote>

Now if you want to move to <a href="https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp" rel="noreferrer">new behaviors</a> you have to add this line in your <code>my.cnf</code> in the [mysqld] section.

<pre><code>explicit_defaults_for_timestamp = 1
</code></pre>

The location of my.cnf (or other config files) vary from one system to another. If you can't find it refer to <a href="https://dev.mysql.com/doc/refman/5.7/en/option-files.html" rel="noreferrer">https://dev.mysql.com/doc/refman/5.7/en/option-files.html</a>

blocks|key|2816311|text|在mysql命令行中执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2816312|mysql>+SHOW+GLOBAL+VARIABLES+LIKE+'%25timestamp%25';
%2B---------------------------------%2B-------%2B
%7C+Variable_name+++++++++++++++++++%7C+Value+%7C
%2B---------------------------------%2B-------%2B
%7C+explicit_defaults_for_timestamp+%7C+OFF+++%7C
%7C+log_timestamps++++++++++++++++++%7C+UTC+++%7C
%2B---------------------------------%2B-------%2B
2+rows+in+set+(0.01+sec)

mysql>+SET+GLOBAL+explicit_defaults_for_timestamp+=+1;
Query+OK,+0+rows+affected+(0.00+sec)

mysql>+SHOW+GLOBAL+VARIABLES+LIKE+'%25timestamp%25';
%2B---------------------------------%2B-------%2B
%7C+Variable_name+++++++++++++++++++%7C+Value+%7C
%2B---------------------------------%2B-------%2B
%7C+explicit_defaults_for_timestamp+%7C+ON++++%7C
%7C+log_timestamps++++++++++++++++++%7C+UTC+++%7C
%2B---------------------------------%2B-------%2B
2+rows+in+set+(0.00+sec)|code-block|syntax|javascript|2816313|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In your mysql command line do the following:

<pre class="lang-sql prettyprint-override"><code>mysql&gt; SHOW GLOBAL VARIABLES LIKE '%timestamp%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | OFF |
| log_timestamps | UTC |
+---------------------------------+-------+
2 rows in set (0.01 sec)

mysql&gt; SET GLOBAL explicit_defaults_for_timestamp = 1;
Query OK, 0 rows affected (0.00 sec)

mysql&gt; SHOW GLOBAL VARIABLES LIKE '%timestamp%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | ON |
| log_timestamps | UTC |
+---------------------------------+-------+
2 rows in set (0.00 sec)
</code></pre>

blocks|key|3028604|text|在Windows平台上，|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3028605|3028606|找到您的my.ini配置文件。|ordered-list-item|3028607|在my.ini中转到[mysqld]部分。|CODE|3028608|添加不带引号的explicit_defaults_for_timestamp=true并保存change.|3028609|Start+mysqld|3028610|3028611|这对我很有效(Windows7旗舰版32位)|3028612|entityMap^0|1|7|0|0|4|6|0|1|6|A|8|0|7|10|7|10|0|6|6|0|0|7|E|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|L]]|D|@]|E|$]]|$1|M|3|N|5|I|7|17|8|@$9|18|A|19|B|C]|$9|1A|A|1B|B|L]]|D|@]|E|$]]|$1|O|3|P|5|I|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|U|$]]

On a Windows platform,
<ol>
<li>Find your my.ini configuration file.</li>
<li>In my.ini go to the <code>[mysqld]</code> section.</li>
<li>Add <code>explicit_defaults_for_timestamp=true</code> without quotes and save the change.</li>
<li>Start mysqld</li>
</ol>
This worked for me (windows 7 Ultimate 32bit)

blocks|key|190813|text|对我来说，将短语"explicit_defaults_for_timestamp+=+ON"“不带引号添加到配置文件my.ini中是可行的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|190814|确保将此短语添加到配置文件中mysqld语句的正下方。|190815|如果您执行了MySQL的默认安装，您将在C:\ProgramData\MySQL\MySQL+Server+5.7下找到my.ini。|190816|entityMap^0|8|12|1M|6|0|0|K|11|1O|6|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|R|8|@]|E|@]|F|$]]|$1|I|3|J|5|6|7|S|8|@$9|T|A|U|B|D]|$9|V|A|W|B|D]]|E|@]|F|$]]|$1|K|3|-4|5|6|7|X|8|@]|E|@]|F|$]]]|L|$]]

For me it worked to add the phrase "explicit_defaults_for_timestamp = ON" without quotes into the config file <code>my.ini</code>. 

Make sure you add this phrase right underneath the [mysqld] statement in the config file. 

You will find <code>my.ini</code> under <code>C:\ProgramData\MySQL\MySQL Server 5.7</code> if you had conducted the default installation of MySQL.

blocks|key|3028681|text|在Windows上，您可以使用option键运行服务器，无需更改ini文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028682|"C:\mysql\bin\mysqld.exe"+--explicit_defaults_for_timestamp=1|offset|length|style|CODE|3028683|entityMap^0|0|0|1P|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

On Windows you can run server with option key, no need to change ini files.

<code>"C:\mysql\bin\mysqld.exe" --explicit_defaults_for_timestamp=1</code>

blocks|key|3028737|text|在mysql命令行中：SET+explicit_defaults_for_timestamp=1|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3028738|entityMap^0|B|11|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In your mysql command line: <code>SET explicit_defaults_for_timestamp=1</code>

blocks|key|190773|text|在我的系统(Windows8.1)上，问题出在服务器配置上。服务器在我安装的时候第一次就能工作了。但是，我忘了勾选"run+as+a+service“选项，这导致了所有的问题。我在SO上尝试了所有可能的解决方案，但都不起作用。因此，我决定重新安装MySQL工作台。在执行我之前用于安装MySQL工作台的同一个msi文件时，我重新配置了服务器，并允许将服务器作为服务运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190774|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

On my system (Windows 8.1), the problem was with the server configuration. The server worked for the first time when I installed it. However, I forgot to check the "run as a service" option and this caused all the problem. I tried all possible solutions available on SO but nothing worked. So, I decided to reinstall MySQL Workbench. On executing the same msi file that I earlier used to install MySQL workbench, I reconfigured the server and allowed to run the server as a service.

blocks|key|194986|text|在Windows上--打开位于"C:\ProgramData\MySQL\MySQL+Server5.6“的my.ini文件，在下一行中找到"mysqld”(不带引号)添加explicit_defaults_for_timestamp，然后保存更改。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194987|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

On Windows -- open my.ini file, present at "C:\ProgramData\MySQL\MySQL Server 5.6", find "[mysqld]" (without quotes) in next line add explicit_defaults_for_timestamp and then save the changes.

blocks|key|192852|text|我使用的是Windows+8.1，并使用以下命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192853|c:\wamp\bin\mysql\mysql5.6.12\bin\mysql.exe|code-block|syntax|javascript|192854|而不是|192855|+c:\wamp\bin\mysql\mysql5.6.12\bin\mysqld|192856|它工作得很好..|192857|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I'm Using Windows 8.1 and I use this command

<pre><code>c:\wamp\bin\mysql\mysql5.6.12\bin\mysql.exe
</code></pre>

instead of

<pre><code> c:\wamp\bin\mysql\mysql5.6.12\bin\mysqld
</code></pre>

and it works fine..

When I try to start my mySQL server I get message:

<blockquote>
 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
 Please use --explicit_defaults_for_timestamp server option (see
 documentation for more details).
</blockquote>

I find answer on: 
<a href="http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp" rel="noreferrer">http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp</a>

But how to enable it? Where?

How to enable explicit_defaults_for_timestamp?

SQL Server

服务器

Windows

MySQL

当我尝试启动mySQL服务器时，收到消息：带有隐式默认值的警告时间戳是使用--explicit_defaults_  _ TIMESTAMP服务器选项(有关更多详细信息，请参阅文档)。我的答案是：但是如何启用它呢？哪里?

问如何启用explicit_defaults_for_timestamp？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何启用explicit_defaults_for_timestamp？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何启用explicit_defaults_for_timestamp？
EN