/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

11 votes246 views3 answers
Pl sql example
SQL
5 votes248 views3 answers
Sql max value in column
SQL
0 vote263 views1 answer
Pl sql disable trigger
SQL
1 vote245 views1 answer
Epoch time converter in snowflake
SQL
1 vote239 views1 answer
How to update date add hours in postgresql
SQL
6 votes233 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote234 views1 answer
Tsql cmd exec script from file
SQL
0 vote264 views1 answer
Suhaib
SQL
0 vote216 views8 answers
Convert sql query to linq online
SQL
1 vote220 views2 answers
Pl sql case
SQL

Share