/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

0 vote263 views1 answer
Stored function in sql
SQL
19 votes260 views2 answers
Mysql tinyint max value
SQL
0 vote254 views1 answer
Oracle to_number
SQL
0 vote266 views1 answer
Sql where part of string match
SQL
2 votes256 views1 answer
Oracle number to percentage
SQL
8 votes287 views1 answer
Mysql limit rows
SQL
0 vote259 views1 answer
Tsql pad left
SQL
34 votes296 views6 answers
Alter table add foreign key mysql
SQL
0 vote280 views1 answer
Mariadb cast to int
SQL
1 vote246 views1 answer
Mysql sort by date column
SQL

Share