/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 vote142 views1 answer
Database Queries
SQL
0 vote153 views1 answer
Mysql make date from 2 column
SQL
0 vote146 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
7 votes158 views3 answers
Foreign key oracle
SQL
1 vote286 views1 answer
Sql check roles
SQL
0 vote173 views1 answer
SQL joins in python
SQL
0 vote143 views1 answer
Delete double on SQL with multiple primary keys
SQL
5 votes144 views5 answers
Find max number in sql
SQL
0 vote162 views1 answer
Postgresql function ROUND
SQL
2 votes144 views1 answer
Set column to not null mysql
SQL

Share