/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

2 votes153 views1 answer
Install postgresql centos 5
SQL
15 votes143 views3 answers
Find duplicate keys in mysql
SQL
2 votes143 views5 answers
SQL trigger
SQL
0 vote150 views2 answers
Port 5432 is already in use mac
SQL
0 vote137 views1 answer
Sql sort ages
SQL
0 vote156 views1 answer
Mysql root localhost run
SQL
1 vote142 views1 answer
Pl sql insert into table
SQL
0 vote150 views1 answer
How to move a column to different spot mysql
SQL
0 vote164 views1 answer
Pl sql search in all packages
SQL
0 vote129 views1 answer
First mysql
SQL

Share