SQL

how to set an already made tables auto increment in mysql

# To Set the value of auto increment in an already existing table use:
ALTER TABLE tables_name AUTO_INCREMENT=500; # Or whatever number you desire

create table mysql example auto_increment

Copied
CREATE TABLE animals (
     id MEDIUMINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
);

INSERT INTO animals (name) VALUES
    ('dog'),('cat'),('penguin'),
    ('lax'),('whale'),('ostrich');

SELECT * FROM animals;

how to change the auto increment in existing table mysql

ALTER TABLE tbl_access ADD COLUMN `access_id` int(10) NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST