/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 votes274 views6 answers
Sql add column with default value
SQL
0 vote266 views1 answer
Mysql select where text contains
SQL
1 vote280 views1 answer
Select last row from SQL Table
SQL
0 vote375 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote288 views1 answer
Create another table from existing table sql oracle
SQL
0 vote276 views1 answer
Mysql could not fetch tables
SQL
0 vote275 views1 answer
Oracle sql procedure return value
SQL
0 vote276 views3 answers
Sql all columns
SQL
13 votes275 views2 answers
Sql join
SQL
0 vote292 views1 answer
Sqlite löschen einer tabelle
SQL

Share