/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 vote168 views1 answer
Mysql percentage of total
SQL
1 vote136 views1 answer
Postgresql last element of array
SQL
0 vote187 views2 answers
Sql regex vowel
SQL
0 vote139 views1 answer
Java spring jdbc connect to postgresql
SQL
18 votes207 views2 answers
Sql comments
SQL
1 vote176 views1 answer
Postgres check blocking
SQL
0 vote187 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote192 views2 answers
Timing sql queries
SQL
9 votes199 views6 answers
Sql add column with default value
SQL
0 vote191 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL

Share