Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 修改mysql的主键默认值

修改mysql的主键默认值

WBOY
Release： 2016-06-07 14:57:40
Original
1955 people have browsed it

当你测试的数据被删除时，主键id就会有间隔，可以修改主键的默认值消除间隔 无 alter TABLE syxg_user AUTO_INCREMENT=21

当你测试的数据被删除时，主键id就会有间隔，可以修改主键的默认值消除间隔 
alter TABLE syxg_user AUTO_INCREMENT=21
Copy after login
Related labels：
mysql primary key Revise delete data test default value
source：php.cn
Previous article：最近自动产生的序列的编号 Next article：MySQL实现简单row_number()的模拟
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
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
CSS only method to dynamically modify image src on click without using JavaScript I need to change the src of an image on mouse click using only css like img:active{}
From 2024-04-06 19:25:49
0
1
505
CSS styles not applied to site I'm making a website using Bootstrap5 but the index.css properties are not being applied t...
From 2024-04-06 17:12:23
0
1
336
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