SQL

add auto increment column mysql

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

change auto increment mysql

ALTER TABLE tbname MODIFY COLUMN columname smallint(5) auto_increment

update auto increment value in mysql

ALTER TABLE foobar AUTO_INCREMENT=10;

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

mysql auto increment column

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)
    )

auto increment column in mysql query results

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

mysql get auto_increment value

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';