/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 votes397 views1 answer
Oracle ora-00054 find
SQL
0 vote373 views1 answer
Left join vs inner join performance
SQL
0 vote383 views1 answer
Cube oracle
SQL
0 vote362 views1 answer
How to find table lock and row lock in mysql
SQL
1 vote339 views1 answer
Importance of comment in mysql
SQL
0 vote373 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote378 views1 answer
Mysql text to decimal
SQL
1 vote377 views1 answer
Mysql connect bash
SQL
4 votes373 views1 answer
Data types in sql
SQL
9 votes326 views1 answer
Identity insert on sql server
SQL

Share