/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 vote227 views1 answer
Oracle character set
SQL
4 votes264 views3 answers
Mysql varchar length
SQL
2 votes278 views1 answer
How to find constraints on a table in oracle
SQL
0 vote289 views1 answer
How to run mysql in git bash
SQL
0 vote284 views1 answer
Change magento database url usimg musql
SQL
1 vote289 views1 answer
What is a Database?
SQL
0 vote267 views1 answer
Cara menampilkan user di mysql terminal
SQL
-1 vote256 views1 answer
How to use update trigger in sql
SQL
1 vote274 views4 answers
Sequelize migration default value
SQL
0 vote266 views2 answers
How to relationship query two different tables in MySQL
SQL

Share