/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 votes163 views2 answers
Sql limit order by
SQL
1 vote149 views1 answer
Sqlite check if row exists
SQL
1 vote163 views1 answer
Show table status command in mysql
SQL
3 votes159 views4 answers
Mysql delete duplicate rows
SQL
6 votes177 views1 answer
Oracle trigger after logon on schema
SQL
0 vote177 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote175 views1 answer
Running percentage of total postgres
SQL
7 votes168 views2 answers
Get database size mysql
SQL
0 vote164 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
10 votes173 views2 answers
Sql rtrim
SQL

Share