/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 vote325 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote302 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote265 views1 answer
Print sum of values sql
SQL
15 votes320 views4 answers
Export mysql db using command line
SQL
0 vote290 views2 answers
Update all linkedserver tables with openquery on db
SQL
6 votes291 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
1 vote254 views1 answer
Unique vs distinct sql
SQL
1 vote311 views3 answers
Mysql connection string
SQL
0 vote299 views1 answer
SqlFunction does not exist
SQL
0 vote301 views1 answer
How to create an SQL save method in ruby
SQL

Share