/SQL/Auto increment column in mysql query results

Auto increment column in mysql query results

Auto increment column in mysql query results

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

1

Add auto_increment column to existing table mysql

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT UNIQUE FIRST

-1

Similar codes

0 vote231 views1 answer
Alter domain sql
SQL
1 vote215 views1 answer
Flask sqlalchemy default value
SQL
0 vote205 views1 answer
Product of a column in mysql
SQL
7 votes231 views6 answers
Mysql group concat
SQL
0 vote203 views1 answer
Mysql workbench indent formatting
SQL
19 votes195 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote199 views1 answer
Oracle sql date winter time
SQL
0 vote226 views2 answers
Plpgsql
SQL
0 vote211 views1 answer
Postgres read table structure
SQL
0 vote205 views1 answer
Psql select * from table
SQL

Share