/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

28 votes332 views6 answers
Mysql change user password
SQL
-1 vote347 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
5 votes330 views6 answers
Sql foreign key
SQL
0 vote335 views1 answer
Sql delete from with relation
SQL
4 votes312 views1 answer
Oracle delete last row
SQL
14 votes332 views6 answers
Auto_increment mysql
SQL
0 vote342 views1 answer
C# get sql min date
SQL
0 vote368 views2 answers
What is rownum in oracle
SQL
3 votes515 views6 answers
Sql unique select
SQL
0 vote324 views1 answer
Day of the week sqlite
SQL

Share