/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 votes133 views2 answers
Oracle timestamp to date
SQL
16 votes146 views3 answers
Update table from another table
SQL
4 votes142 views4 answers
Sqlite describe table
SQL
18 votes139 views6 answers
Creating table in MySQL
SQL
0 vote212 views1 answer
Postgresql powershell query
SQL
22 votes137 views4 answers
Show list of users in mysql
SQL
1 vote141 views1 answer
Mysql remove last empty newline
SQL
7 votes144 views2 answers
Mysql check db size
SQL
2 votes137 views1 answer
Oracle generated column
SQL
1 vote143 views1 answer
Postgres convert date to string
SQL

Share