/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 vote335 views1 answer
Sql where last 12 months
SQL
0 vote355 views1 answer
Select place default lat long
SQL
0 vote321 views1 answer
Cara menampilkan user di mysql terminal
SQL
8 votes327 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote338 views1 answer
Implicit inner join table alias
SQL
-1 vote339 views2 answers
Postgresql user permissions to database
SQL
0 vote313 views1 answer
Sqlserver now
SQL
0 vote334 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote313 views1 answer
Search db for table name
SQL
14 votes405 views1 answer
How to export db from mysql
SQL

Share