/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

13 votes219 views2 answers
Oracle inner join
SQL
0 vote187 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote189 views1 answer
Change database name psql 8
SQL
6 votes185 views1 answer
Oracle rank() over (partition)
SQL
0 vote189 views1 answer
Sql server udf performance
SQL
2 votes208 views2 answers
Install sqlalchemy
SQL
12 votes189 views4 answers
Import mysql database command line linux
SQL
0 vote266 views1 answer
How to check event scheduler status mysql
SQL
0 vote190 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
3 votes199 views2 answers
Postgres alter table owner
SQL

Share