/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

9 votes136 views1 answer
Oracle get table schema
SQL
0 vote125 views1 answer
Mysql function variable
SQL
3 votes128 views1 answer
Postgresql cast
SQL
18 votes159 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
1 vote139 views1 answer
Default
SQL
6 votes151 views2 answers
Mysql timestamp to date
SQL
0 vote145 views1 answer
Sql max of two values
SQL
1 vote129 views1 answer
Hackerrank sql test solutions
SQL
2 votes127 views1 answer
Oracle find constraints referencing a table
SQL
0 vote124 views1 answer
Postgres set default schema
SQL

Share