/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

5 votes305 views5 answers
Find max number in sql
SQL
0 vote303 views1 answer
Print mysql
SQL
0 vote235 views1 answer
Sqlalchemy existing database
SQL
1 vote318 views1 answer
Mysql curdate between two dates
SQL
0 vote310 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote321 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote292 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote288 views1 answer
Initcap in sql
SQL
0 vote310 views1 answer
Alter boolean column postgresql
SQL
1 vote283 views1 answer
Check message id sql server
SQL

Share