/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

9 votes183 views3 answers
Find all tables with column name
SQL
0 vote187 views1 answer
Select into table variable
SQL
1 vote188 views1 answer
T-SQL Alter the column data type
SQL
5 votes760 views1 answer
Oracle ora-00054 find
SQL
0 vote239 views1 answer
Cannot start database server xampp mac os
SQL
14 votes199 views3 answers
SQL trim
SQL
0 vote203 views1 answer
Sql insert query list of dictionaries
SQL
0 vote178 views1 answer
Install sql server windows 10
SQL
0 vote168 views1 answer
Suse start MySQL
SQL
3 votes172 views2 answers
Sql end of month
SQL

Share