Answers for "mysql how to change auto increment"

SQL
3

make a field auto_increment mysql

ALTER TABLE document MODIFY COLUMN document_id INT auto_increment
Posted by: Guest on September-08-2021
0

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;
Posted by: Guest on November-05-2021

Code answers related to "mysql how to change auto increment"

Code answers related to "SQL"

Browse Popular Code Answers by Language