/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

6 votes177 views2 answers
Join vs union
SQL
-1 vote174 views1 answer
Window functions in sql
SQL
0 vote176 views1 answer
Sql common columns
SQL
0 vote174 views1 answer
Mysql into outfile with headers
SQL
-1 vote191 views3 answers
Compute age mysql
SQL
1 vote138 views1 answer
Oracle character set
SQL
0 vote184 views2 answers
Sql query in dax power bi
SQL
0 vote176 views1 answer
Select row from mysql where date more than 30 days
SQL
3 votes195 views4 answers
Psql list tables in schema
SQL
1 vote175 views1 answer
Is sql fast
SQL

Share