/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

1 vote231 views3 answers
How to update column name in psql
SQL
4 votes199 views2 answers
Linq join
SQL
0 vote243 views1 answer
Create table like sql
SQL
2 votes287 views2 answers
Set value to null sql
SQL
0 vote217 views1 answer
Oracle table privileges
SQL
0 vote262 views1 answer
Mysql default uuid
SQL
0 vote189 views2 answers
Insert into
SQL
3 votes260 views1 answer
How to uninstall microsoft sql server
SQL
5 votes208 views1 answer
Oracle get nls settings
SQL
0 vote240 views1 answer
Enable outgoing remote MySQL access
SQL

Share