/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

4 votes227 views3 answers
Check if two date ranges overlap sql server
SQL
6 votes216 views3 answers
Mysql server is not starting xampp
SQL
1 vote214 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote232 views1 answer
Query archive mode
SQL
0 vote231 views1 answer
Print hello world in plsql
SQL
1 vote264 views1 answer
Nvl postgres
SQL
0 vote225 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote267 views1 answer
How to check rollback status in oracle
SQL
8 votes228 views3 answers
Postgres connection string
SQL
0 vote256 views1 answer
Get initial in sql
SQL

Share