/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

0 vote165 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote151 views1 answer
SQL loop with cursor
SQL
-1 vote153 views5 answers
Online sql to linq generator
SQL
4 votes149 views1 answer
Mysql copy table with new name
SQL
0 vote179 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote148 views1 answer
Loading local data is disabled mysql
SQL
2 votes151 views2 answers
How to view created temporary tables in mysql
SQL
0 vote194 views1 answer
Reindexing all tables sql server
SQL
1 vote152 views1 answer
How to get the date diff on once field in sql server
SQL
1 vote155 views1 answer
Mariadb case switch
SQL

Share