change auto_increment value in mysql

Question

I want to change auto_increment value in mysql. Right now it's 10. I have gone through this question in stackoverflow.

I tried with

SET @@auto_increment_increment=1;

But when I checked that variable by show variable command then my result was like,

SHOW VARIABLES LIKE 'auto_inc%';

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 10    |
| auto_increment_offset    | 1     |
+--------------------------+-------+

I am running my server on windows azure. Is that any problem with that?

Possible duplicate of [How to reset AUTO\_INCREMENT in MySQL?](http://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql) — Matthew Leffler, Nov 29 '16 at 00:54

score 3 · Answer 1 · answered May 23 '14 at 15:43

3

Try executing this

SET GLOBAL auto_increment_increment =1;

You can also set it on table level

ALTER TABLE yourtable AUTO_INCREMENT = 1;

answered May 23 '14 at 15:43

Mad Dog Tannen

7,129
5
31
55

ERROR: Access denied; you need (at least one of) the SUPER privilege(s) for this operation. – user3609998 May 23 '14 at 15:47
The second one adjusts the initial sequence, not the increment increment. – tadman May 23 '14 at 15:47
Setting globals requires administrator access. – tadman May 23 '14 at 15:48
is there any option in windows azure to do this? – user3609998 May 23 '14 at 15:48
I tried it with alter table too. but it's still incrementing by 10. – user3609998 May 23 '14 at 15:51
When you execute `SHOW GLOBAL VARIABLES LIKE 'auto_inc%';` , does it say also 10? ` – Mad Dog Tannen May 23 '14 at 16:27

change auto_increment value in mysql

1 Answers1