/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 vote260 views1 answer
Oracle exchange subpartition
SQL
1 vote285 views1 answer
How to set up a trigger in sql
SQL
0 vote289 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote295 views1 answer
Insert into table with only identity column
SQL
0 vote219 views2 answers
Delete the last item in a table sql
SQL
1 vote264 views1 answer
Oracle grant on all tables in schema
SQL
0 vote217 views1 answer
Oracle sql developer script output limit
SQL
0 vote279 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
14 votes274 views4 answers
Online sql compiler
SQL
0 vote256 views1 answer
In mysql workbench contnent not feching
SQL

Share