/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 vote291 views1 answer
Sql DATE = GETDATE()
SQL
5 votes269 views1 answer
Sql first day of current year
SQL
0 vote333 views1 answer
How to compile a function in oracle
SQL
0 vote301 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote304 views1 answer
Create boolean column in MySQL with false as default value?
SQL
7 votes298 views3 answers
SQL create a new table
SQL
4 votes298 views2 answers
Sql offset
SQL
0 vote243 views0 answer
SQL
6 votes295 views2 answers
What is non relational database
SQL
0 vote304 views1 answer
Openquery join two tables
SQL

Share