/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

1 vote120 views1 answer
Sqlite3 read only
SQL
2 votes98 views1 answer
SELECT INTO
SQL
0 vote121 views1 answer
How to insert same table data using mysql query
SQL
9 votes103 views2 answers
Nosql databases
SQL
0 vote101 views1 answer
Check connections to database postgres
SQL
3 votes103 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
5 votes157 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote117 views2 answers
Reseed sql identity
SQL
1 vote95 views1 answer
Set statistics on in ssms
SQL
2 votes106 views2 answers
Mysql add hours to time field
SQL

Share