Answered by : unsightly-unicorn-r181j3dxt50k

ALTER TABLE document MODIFY COLUMN document_id INT auto_increment

Source : https://stackoverflow.com/questions/2169080/alter-a-mysql-column-to-be-auto-increment | Last Update : Wed, 15 Sep 21

Answered by : armando-flores

ALTER TABLE `table_name` ADD COLUMN `id` INT AUTO_INCREMENT UNIQUE FIRST;

Source : | Last Update : Sun, 21 Aug 22

Answered by : obnoxious-osprey-0adbn3x7ugpo

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

Source : https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql | Last Update : Thu, 24 Dec 20

Answered by : snippets

SET @auto_increment=0;
SELECT @auto_increment := @auto_increment+1 AS `No`;

Source : | Last Update : Sun, 04 Apr 21

Answered by : tiago-frana

CREATE TABLE IF NOT EXISTS blog_users ( id INT NOT NULL AUTO_INCREMENT, email VARCHAR(255) NOT NULL, password VARCHAR(255) NOT NULL, PRIMARY KEY (id) )

Source : | Last Update : Thu, 12 May 22