Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"_MySQL

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"_MySQL

WBOY
Release： 2016-06-01 13:30:39
Original
1256 people have browsed it

bitsCN.com


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"

 

NO_AUTO_VALUE_ON_ZERO影响AUTO_INCREMENT列的处理。

 

一般情况，你可以向该列插入NULL或0生成下一个序列号。

 

NO_AUTO_VALUE_ON_ZERO禁用0，因此只有NULL可以生成下一个序列号。 

 

如 果将0保存到表的AUTO_INCREMENT列，该模式会很有用。

 

(不推荐采用该惯例)。例如，如果你用mysqldump转储表并重载，MySQL 遇到0值一般会生成新的序列号，生成的表的内容与转储的表不同。

 

重载转储文件前启用NO_AUTO_VALUE_ON_ZERO可以解决该问题。

 

bitsCN.com
source：php.cn
Previous article：101个MySQL的调节和优化的提示_MySQL Next article：有关Mysql连接问题_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2385
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2512
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2133
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
2005
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2083
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template